Oracle

Lplus/nologConn System/[email protected]Create tablespace aries logging datafile ' e:\oracle\oradata\orcl\aries.dbf ' size 32m autoextend on next 32m maxsize 2048m Extent management Local;Create user survey identified by 1234 default Tablespace

1. View the respective roles owned by all users in the database:SELECT * FROM (SELECT DISTINCT Connect_by_root grantee username,granted_roleFrom Dba_role_privsConnect by prior Granted_role =grantee) awhere exists (select 1 from dba_users b where

Scenario Description:During the Oracle installation process, a DBCA error occurred in the header during the creation of the database!Detection confirm environment: firewall is off.The reason: There is a need to note that in setting up the Oracle

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

Collection operationsDesc job_history: Changing the position of historyJob_history: History tableVnion: Duplicate values retain only one remove duplicate value ★Vnion all: Retain all duplicate values without removing duplicate values ★Intersect:

Oracle Table complex Query aggregation functionMax (field value)--max valueMin (field value)--Minimum valuesum (field value)--Seek sumAVG (field value)--averagingCount (field value)--Number of numbersGROUP BY and HAVING clauseGROUP BY: used to group

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

After Oracle is installed, the default archive mode is turned on, and a large number of logs fill the disk instantaneously, so in the development environment, it is often necessary to turn off archive mode.1. Connect to the database as an

Oracle Auto-Disconnect database connection workaround method One, the direct modification of the resource configuration file is done in three steps in the Sqlplus environment.        The first step is to query the resource file and find the profile

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

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

Oracle:Begin${sql}EndNote: There must be a begin end;Ora-00933:sql command did not end correctly; Bad SQL Grammar []; Nested exception is Java.sql.sqlsyntaxerrorexception:ora-00933:sql command did not end correctlyMysql:${sql}Can not add when

Before the work encountered a problem, need to find all the sub-nodes under the tree structure, if the program will be repeated query database, the performance has an impact on the online search, you can use Oracle recursive query, examples are as

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

1, change the client character set: run regedit from the Windows Run menu, modify the registryStart, Run, Rededit Under registry Editor-> HKEY_LOCAL_MACHINE-Software->oracle->key_xe->right WINDOW DOUBLE CLICK Nls_la NG-and change-VALUE to

1. Stored ProceduresCREATE OR REPLACE PROCEDURESp_name (Pm_name [in/out/in out] pm_type ...){ as}[Description (variable definition) section]BEGINExecutable section[EXCEPTION]Error Handling sectionEND[Sp_name];·　　　　Parameters:In defines an input

Establish stored procedures on ORACLE server that can be called by multiple applications, can pass parameters to stored procedures, and can be passed back to stored proceduresTo create a stored procedure syntax:CREATE [OR REPLACE] PROCEDURE

The syntax for creating a function is as follows:CREATE [OR REPLACE] FUNCTION function_name[(argment [{in | Out | In Out}] Type,argment [{in | Out | In Out}] Type]RETURN Return_type{is | As}BEGINFunction_bodyEXCEPTIONOther statementsEND;Cases:1

1. Create TABLE spaces:begindeclarecnt integer: = 0; BEGIN Select 1 to CNT from dual where exists (SELECT * from user_tablespaces where tablespace_name = UPPER (TRIM (' TEST ') ))); IF cnt! = 0 Then DECLARE s VARCHAR2 (500);