Oracle

I. Statistical aspects:Sum() Over([Partition by] [Order by])Sum() Over([Partition by] [Order by]RowsbetweenPreceding andfollowing)Sum() Over([Partition by] [Order by]RowsbetweenPreceding and CurrentRow)Sum() Over([Partition by] [Order

Tag: T-SQL statement cannot execute under stored procedure call instead of Div Note command executionWhat is a stored procedure? A stored procedure is a named PL/SQL program block, which is a block of code that consists of some T-SQL statements that

  Configuring Monitoring (1) Oracleoradb11g_home1tnslistener: Indicates the listener service, which must be turned on if the client wants to connect to the database. The service also has to work in the development of the program. (2)

Read consistency: Oracle guarantees read consistency through multiple versions and flashback mechanisms. Ensure that queries are consistent from one point in time. In Oracle, the version of the system modification is controlled primarily by the SCN

AuditTurn on switch parameters:Sql> Show Parameter Audit_trailSet audit options:Each time a new audit option is set, the test user needs to reconnectSYS preparation:sql> drop user User01 cascade;Sql> create user User01 identified by password;Sql>

B-tree and the B+treeat present, most database systems and file systems are used B-tree or its variants B+tree as the index structure. first, for a single node, it is a Key Value structure, Key is the column that makes the citation, value There are

Database managementThere are 4 ways to close the database:1.shutdown Modes shutdown mode2.shutdown Normal shutdown3.shutdown immediate immediately close ★ Common commands4.shutdown abort directly shuts down the databaseStartup: RestartDbstart:

Oracle The version is very many, first look at a version of the 11g description:Attention: after the Oracle 9.2 version number, Oracle's maintenance release numbers are changed at the second digit bit. And before that is in the third digit digit.1.

Introduction to Oracle DatabaseMaybe a lot of people are familiar with SQL Server, not much about Oracle database, here is a brief introductionThe founder of Oracle database is Lawrence Ellis.Oracle database can be used by multiple operating

1. Access to Computer Management >> services, stop all Oracle Services2. Start Menu >> program >>oracle>>oracle Install product >>universal Installer, run the programSelect "Uninstall Product";Select "Expand All" and then select "Delete" after all

Self-connect:Empid ename Mgridabc101 def 100102 XYZ 100Emp:mgr:Empid ename Mgrid Empid mgrnameABC (ABC)101 def 100102 XYZ 100101 DEF-ABC102 XYZ (ABC)Select Emp.ename, Mgr.mgrnameFrom EMP, Mgrwhere Emp.mgrid=mgr.empidEmp:mgr:Empid ename mgrid empid

1. View All Users:SELECT * from Dba_users;SELECT * from All_users;SELECT * from User_users;2. View user or role system permissions (System permissions that are directly assigned to a user or role):SELECT * from Dba_sys_privs;SELECT * from

(Create TABLE table name (field) storage (Buffer_pool keep); --cache the table to keep in the table name storage (Buffer_pool keep);--caches existing tables to keep CREATE TABLE table name (field: ) Storage (Buffer_pool Keep) cache;--create cache

An Oracle database object, also known as a schema object, is a collection of logical structures in which the most basic database object is a table. Common database objects include synonyms, sequences, views, and so on.1. ViewViews can restrict a set

Thanks to the following author's share: http://blog.csdn.net/wildboy2001/article/details/7271877http://blog.csdn.net/lsyuan1989/article/details/50418665There are two ways to import and export a database: import: Imp IMPDP "Data Pump"Export: Exp

Oracle Paging: Keyword rownumSELECTEMPNO,ENAME,JOB,MGR,HireDate,SAL,COMM,DEPTNOFrom(SELECT a.*, ROWNUM RNFrom (SELECT EMPNO,ENAME,JOB,MGR,To_char (hiredate, ' yyyy-mm-dd ') hiredate,SAL,COMM,DEPTNOFromEmpORDER by EMPNO) AWHERE ROWNUM

Silent Installation Reference: http://www.cnblogs.com/colmeluna/p/5686142.htmlIn the actual installation:1. Skip the second step to set the swap area space2. No prompt to execute orainstroot.sh after installation is complete, only root.shBuild

In Oracle, you can use the drop, delete, and truncate three commands to delete a table from a database.1. Delete and truncate both delete the contents of the table and cannot delete the structure of the table, while the drop is to delete the

Error occurredORA-01034 ORACLE Not availableORA-27101 Shared Memory Realm does not exist　　　　WorkaroundStart monitoring:#lsnrctl startStart Oracle Services$sqlplus/nologSql> Conn/as SYSDBASql> StartupStart Oracle ServicesError

1. You can use the VI command to view files under Linux in a similar notepad.2.Redhat shut down the firewall, command systemctl Stop FIREWALLD view the Firewall status command systemctl status FIREWALLD3. Log in to the database Sqlplus/nolog