Oracle

1. The date in Oracle is converted to yyyy mm month DD Day formSelect to_char (sysdate,' "Year" MM "month" DD "Day")from dual;2. Oracle Analytic function syntax2.1 ORDER bySelect E.last_name, e.manager_id, e.salary, avgover as--

Install oracle11g to 100% when suddenly stuck, Oracle database configuration assistant, such as:ALT + Tab button appears, template GENERAL-PURPOSE.DBC does not existThis is required two compressed files simultaneously selected together extract to

Oracle database table Space usage query:Select B.file_name Physical file name,B.tablespace_name table Space,b.bytes/1024/1024 size M,(B.bytes-sum (NVL (a.bytes,0)))/1024/1024 has used M,SUBSTR ((B.bytes-sum (NVL (a.bytes,0))/(b.bytes) *100,1,5)

It's been all the time. SQL Server suddenly with Oracle egg pain of the even stored procedures to execute a query will not be all kinds of Baidu now record the following syntax problemsOrcale The syntax for creating a stored procedure,Create or

This article mainly introduces the use of RowNum and Row_number () in Oracle, as well as the differences and links, very detailed, the need for small partners can refer to.Row_number () over (partition by col1 ORDER by col2) indicates that,

View all user partition tables and partitioning policies (1, Level 2 partition tables are included):SELECT p.table_name as table name, decode (P.partitioning_key_count, 1, ' primary partition ') as partition type,P.partitioning_type as partition

1. Create a table in SYS mode that records the details of the client's login to the database serverCreate Tablelogon_logs (logon_time date,usernamevarchar2( -), machinevarchar2( -), Ipadrvarchar2( -), programvarchar2( -), modulevarchar2( -),

1. Create a table spaceCreate'/u01/oracle/oradata/orcl/yyy01.dbf' on Next 50m maxsize unlimitedextent Management local2. Create a userCreate User by yyy default tablespace yyy Temporary Temp DEFAULT3. User authorization--Grant/revoke Object

1. See if Oralce is an archive or non-archive modeSql> select Name,log_mode from V$database;NAME Log_mode---------------------------------------- ------------------------------------YOON ARCHIVELOGSql> select Name,log_mode from V$database;NAME

First step: Login After root login, switch to Oracle user, enter Su OracleStep Two: Connect Under Oracle user, enter Sqlplus/nologStep Three: Use Administrator privileges Input Connect/as SYSDBAFourth step: Start/Close service Input StartupStartup

1. The Start command is[Email protected] ~]$ CD $ORACLE _home/bin[Email protected] ~]$/emctl start dbconsoleStop command Yes[Email protected] ~]$./emctl Stop DbconsoleView OEM Status[Email protected] ~]$/emctl status DbconsoleOracle's environment

Set Linesize 132Column name format A30Column value Format A25SelectX.KSPPINM name,Y.KSPPSTVL value,Y.KSPPSTDF IsDefault,Decode (Bitand (y.ksppstvf,7), 1, ' MODIFIED ', 4, ' system_mod ', ' FALSE ') Ismod,Decode (Bitand (y.ksppstvf,2), 2, ' TRUE ', '

Sql> create Pfile from SPFile;Modify the Pfile file, add the implied parameter *._enable_rename_user= ' TRUE ' to start the database in restrict mode1, [[email protected] ~]$ cd/u01/app/oracle/product/11.2.0/db1/dbs/2, [[email protected] dbs]$

1 　　 Public Static voidMain (string[] args)throwsSQLException {223344 String driver= "Oracle.jdbc.driver.OracleDriver";55 String url= "Jdbc:oracle:thin: @www. Ee.w.www:1521:orcl"; 66 String user= "RRR"; 77 String password= "RRR";8899 Connection

1. CMD on the Oracle serverExecutive LsnrctlExecute startAfter a long time, the prompt listener has been started.Perform status againIt was a long time before the command was executed successfully.It is best to find the cause because the

Occurs when debugging an Oracle Query statement: Column 650 not explicitly defined this.width=650; "src=" http://s1.51cto.com/wyfs02/M01/7A/48/ Wkiom1am4hfxggskaab9ne12vws774.png "title=" Oracle undefined column. png "alt="

The NVL () function is a function in Oracle/plpgsql in the form of: NVL (string1, Replace_with)Function: If the string1 bit is null, then the NVL () function returns the value of Replace_with, otherwise the value of STING1 is returned.Note: Sting1

Export and import a specified table from Oracle Export from source database: Exp user1/pwd @ server1 file = c: \ temp \ exp. dmp tables = (table1, table2) Import to the target database: Exp user2/pwd @ server2 file = c: \ temp \ exp. dmp tables =

Oracle learning database data is saved as a file, oracle Database It is often necessary to generate documents from the data in the database. Because you prefer the script method, you need to set the format when using spool, the following is a simple

Add a disk to a data disk (asmexternal) 1. Create a disk and access both nodes. 2. Check the cluster status [grid @ rac1 ~] $ Crsctl status res-t release name target state server STATE_DETAILS restart Local Resources within ora. DATA. dg ONLINE rac1