Oracle

The Oracle background process starts with the start of the instance, primarily maintaining the stability of the database, which is equivalent to a manager and internal service staff in an enterprise. They do not provide services directly to users.  

Oracle recovery deletes a table or table recordOne: Recovery of the table to the wrong deleted table, as long as not using the Purge permanent delete option, then recover from the flash back area hope is quite large. General steps are: 1, from the

(1)Select To_char (123.56, ' 999.9 ') from dual; would return 123.6Select To_number (' 123.56 ', ' 999.9 ') from dual; Would fail because of error "ora-01722:invalid number"(2)Select To_char (123.56, ' 999 ') from dual; would return 124Select

1. log_archive_dest_1 parameter not set, archive file is not synchronizedMon Nov 07 17:39:12 2016Using standby_archive_dest parameter default value as Use_db_recovery_file_destMon Nov 07 17:40:12 2016Using standby_archive_dest parameter default

Create the user with the following statement: 123 createuser shopping identified by shopping--用户名为shopping，密码为shoppingdefault tablespace shopping --默认表空间为shoppingtemporarytablespace shopping_temp; --默认临时表空间为shopping_temp

Under Linux installed Oracle 11G, due to the installation time did not pay attention to the character set problem, IMPDP import operation after the Chinese garbled.1. Use the command select Userenv (' language ') from dual; viewed normal Oracle and

Start and stop OracleStop and start Oracle needs to be switched to Oracle user only, no other user has this permissionRun Sqlplus but don't log in to Oracle:sqlplus/nologConnect to the Oracle server with the privileges of the system administrator:

We need to make him self-increment when using Oracle to create a primary key, but unlike MySQL, you need to create a sequence that looks like this:You can delete the previously created sequence, and we re-create one:DROP SEQUENCE sjgxqk_sequence;

Start and stop OracleStop and start Oracle needs to be switched to Oracle user only, no other user has this permissionRun Sqlplus but don't log in to Oracle:sqlplus/nologConnect to the Oracle server with the privileges of the system administrator:

1 --General Sort2 SELECT * fromEmpORDER bySalDESC;3 --using column ordering4 SELECT * fromEmpORDER by 6 DESC;5 --Combined Sort6 SELECT * fromEmpORDER byDeptnoASC,1 DESC;7 --translate function, the parameters are denoted by a, B, C,

Select Temp.short_pjt the original name,Temp.fproject_name name after change,Temp.fflow_person_name the author,Temp.fcreate_date Date of submissionFrom (SELECT Head.fsubject,T.fflow_person_name,T.fcreate_date,SUBSTR (Head.fsubject,InStr

SELECT * from T_a A where A.begintime=to_date (' 2013-1-1 ', ' yyyy-mm-dd ');AndSELECT * from T_a A where To_char (a.begintime, ' yyyy-mm-dd ') = ' 2013-1-1 ';The query results are the same.The difference is that the processing steps of the query

Oracle The main users:L Super admin: SysL General Administrator: SystemL General Users: ScottSQLPLUSW Some of the common commands :L Set line Display quantity: Set linesize lengthL settings also show quantity: Set pagesize lengthL Ed and @

--Create TABLE spaceCreate Tablespace Test_tpsDataFile ' D:\app\Administrator\oradata\orcl\test_tps.dbf 'Size 1500MAutoextend on next 5M;--Create a user and make a table spaceCreate user Test_tps identified by Test_tpsDefault Tablespace

Characteristics: Reinstall required: Libaio1_0.3.109-2ubuntu?_amd64.deb. The default Libaio library has a problem and is related to the way it is compiled by default Libaio! The GCC 4.x needs to be reinstalled, and the default GCC 6.x

Oracle data Import Export BASIC Operations Example Data exportA. Full export of database ORCL, username user password Password export to D:\dc.dmpExp User/[email protected] file=d:\dc.dmp full=yFull=y = Full Library exportB. Exporting User1

1. Start-> Settings-> Control Panel-> Management Tool-> Service stop all Oracle services. 2. Start-> Program->oracle-orahome81->oracle installation products-> Universal Installer Uninstall all Oracle products, but Universal Installer itself cannot

have been trying to find out the way ORCL right, today tested a 10g, you can successfully put right.c:\wmpub>sqlplus scott/[email protected]Sql*plus:release 10.2.0.1.0-production on Monday October 31 07:41:29 2016Copyright (c) 1982, 2005, Oracle.

Class.forName ("Oracle.jdbc.driver.OracleDriver"); Connection Conn=NULL; String User=request.getparameter ("UserName"); String Password=request.getparameter ("Password"); Try{conn=drivermanager.getconnection ("Oracle.jdbc.driver.OracleDriver",

Query and delete duplicate records of SQL statement 1, find redundant records in the table, duplicate records are based on a single field (ID) to determine the select * from table where Id in (the Select ID from table group Byid having count (ID) > 1