Oracle

[Email protected] sql>delete from scott.emp;14 rows deleted. [email protected] sql>select s.sid, s.serial#,  2      case bitand (T.flag, power (2, 28))   3         WHEN 0 THEN  ' read committed '   4         ELSE  ' SERIALIZABLE '

Borrowing the experience of othersThe client Oracle server enters the PL/SQL developer times ora-01033:oracle Initializationg or shutdown in progress error message that the application system cannot connect to the Oracle service. Solve the problem

A. DownloadHttp://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html the following two Web site source this official download page Web.Win 32-bit operating system:Http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2

1. First create a table to hold the error message 12345678 CREATETABLE TBL_PROC_ERRMSG(  BIZ_CODE VARCHAR2(50),  ERR_LINE VARCHAR2(10),  ERR_CODE VARCHAR2(10),  MSG VARCHAR2(200),  CRT_TM   DATE DEFAULTSYSDATE); 2.

1. The most efficient way to delete duplicate records (because ROWID is used)Example:DELETE from emp E where E.rowid > (SELECT MIN (x.rowid) from emp X where x.emp_no = E.emp_no);2. In the SQL statement that contains the subquery, pay special

I. Define JobDeclareJob Number;begindbms_job.submit (Job=Job, what='PROC1; PROC2;', Next_date=sysdate, Interval= 'TRUNC (sysdate+ 1)) ';--synchronize once every morningCommit;End;Second, the function of trunc to TIME1.select trunc (sysdate) from

1, ora-00942:table or view does not exist the table you want to manipulate does not already exist, you need to create it first. 2, ora-00922:missing or invalid option it refers to a syntax error. Missing a semicolon or something .3.

1. Create a tableCREATE TABLE Emp_test (ID number (5,2) PRIMARY KEY, NAME VARCHAR2 (a) UNIQUE, BIRTHDAY DATE);--Modify Table nameALTER TABLE emp_test RENAME to TEST1;  --modify table column name alter TABLE emp_test  rename COLUMN name

Select * fromTabs--All tables under the current userSelect * fromDual--Pseudo TableSelect * from(Select * fromFduserOrder byDbms_random.value)whereRowNum=1;--randomly querying a single piece of dataALTER USER TMFC account UNLOCK

First, on the official website of Oracle Download compressed package, I am win764 bit machine.Second, choose to extract two files to the current directory, then the database folder will be generated in the diagram, this article is in the

If there are more than 10 indexes on a table, how do you feel? Obviously it will slow down, delete, change the speed, do not expect developers to build index. My approach is to monitor a long period of time to see which indexes are not used, and

Unzip Instantclient_12_1 to D:\Oracle\instantclient_12_1Create a directory within a folder,/network/adminUnder this directory, create a new file Tnsnames.oraAdamdb = = = = (PROTOCOL = TCP) (HOST = 192.168.1.7) (PORT = 1521)) ==

First, the controller if (!defined (' BasePath '))Exit (' No Direct script access allowed ');Class Topics extends Ci_controller{function __construct (){Parent::__construct ();$this->load->helper (' url ');$this->load->helper (' form ');Note that the

1. First Stop all Oracle services: computer-management-Services and applications---Click Services, the names of all Oracle start-up are all stopped;2. In the environment variable, the corresponding value in the path variable name is deleted by the

1. View processes and Sessions parametersSql> Show parameter processesNAME TYPE VALUEDb_writer_processes Integer 1Gcs_server_processes integer 0Job_queue_processes Integer 10Log_archive_max_processes Integer 2Processes integer 50Sql> Show Parameter

Oracle database to realize the self-growth of ID, need to create a sequence and trigger to implement, a little bit of trouble, but also can be resolved.Directly on the address, first, http://www.wlcrane.com/article.aspx?arid=86This post looks good,

Process of obtaining the memory lock in the shared pool through hard parsing of OracleOCP 1. Obtain the library cache Latch. (1) The text of the SQL statement is not found in the name handle of the parent cursor: select * from gyj_t1 where id = 1;

Oracle11g's dependence judgment reaches the field level In Oracle 10 Gb, the dependency only reaches the object level. That is to say, once the object accessed by the Stored Procedure changes, Oracle sets the stored procedure to INVALID. Therefore,

Solve the problem that an empty Oracle11g table cannot be exported. The deferred_segment_creation parameter is added to Oracle11g. The default value is true when the database is created, which means delayed loading. When no data exists in the table,

Oracle Net Manager Service naming configuration and using PL/SQL to log on to the database, oraclepl We know that four parameters are required to connect to a database: 1. login Username: user; 2. logon password: password; 3. The server address