Oracle

The architecture of Oracle database is to analyze the composition of the database from a certain angle, the working process and how the database manages and organizes the data, including the physical storage structure, logical storage structure,

--Create sequence creation sequence sequence name start with 1--Start value increment by 1--increment maxvalue 99999999--Max Nocycle-If the maximum value is recalculated, the current is not recalculated and cycle is recalculated nocache; --do not

After Oracle installation is complete under Linux, the database command DBCA cannot be used.Workaround:In a 32-bit LINUX environment, the installation of 32-bit oracle11g will have this bug, the main patch (patch name:p8670579_112010_linux.zip) can

1.merge into usesMerge is a very useful feature, almost the same as the merge into function in DB2, similar to the INSERT into on duplicate key in MySQL. MERGE into is a new feature that appears only after Oracle 9i. In a nutshell, it can be a

If you want to define a variable that has a type that is consistent with the data type of a variable or a column in a database table, you can use%type to implement it.If you want to define a variable of a record type that is consistent with a table

Previously, the Oracle 10g was connected using ASP., and recently I wanted to write a small program, so I chose Winform. After a long day, only to discover that Winform and ASP. Oracle is somewhat different.Difference one, read the configuration

Applies To:Oracle server-enterprise edition-version 11.2.0.1 and laterInformation in this document applies to any platform.GOALThis is the to list OCR storage requirement and to provide the location of the diagnostic information if PROT-30 is

At the beginning of Oracle, a lot of unfamiliar, built the library, no users, and did not create table space, directly system users to build a table to add data, a few months past, the table built nearly hundred, the data added tens of thousands of,

Today received a task, need to modify the trigger, because for a long time have not seen about the Oracle trigger, so here through two simple small examples to review the trigger, in case of forgetting.1. Case OneRequirement: Set up trigger, judge

1. View Oracle Current session (number of connections) (process)SELECT sid,serial#,process,logon_time,username,program,status, "' | | sid| | ', ' | | serial#| | "From V$sessionWHERE USERNAME = ' opxx '--User nameand program = ' aspnet_wp.exe

Recently, we often use time functions, write a note here, record your income, and hope to help you.1, for a time such as Sysdate:2015/1/30 14:16:03 how to get only the month and day, at the same time its data type does not change it?The easiest to

This is my table structure:Desc t_student;Name Type Nullable Default Comments------------ ------------ -------- ------- --------stu_id VARCHAR2 (10)Stu_name VARCHAR2 (40)Stu_password VARCHAR2 (+) YStu_age INTEGER YStu_perform FLOAT (2) YInserts a

Recently encountered a situation, you need to restrict a stored procedure only one process is executing, the last execution completes after the next execution. This is similar to the thread synchronization problem in program development.Summarized

LISTENER =(Description_list =(DESCRIPTION =(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))(ADDRESS = (PROTOCOL = TCP) (HOST = raccontroller.cc) (PORT = 1521))))Sid_list_listener =(Sid_list =(Sid_desc =(Global_dbname =

1, oracle11g default to Empty table is not assigned segment, so use EXP export oracle11g database, empty table is not exported.2. After setting the Deferred_segment_creation parameter to False, both the empty table and the non-empty table are

In the project, we used the function of INSTR in Oracle, and learned this knowledge again and again carefully.In Oracle, you can use the INSTR function to judge a string to determine whether it contains the specified character.Its syntax is:INSTR

Sampling table scan (sample table Scan): Scans the returned table for random sampled data, which needs to include the sample option or the sample block option in the FROM statement.Note: Oracle provides sampling table scanning features from oracle8i2

Two small examples of oracle triggers I have received a task today and need to modify the trigger. Because I haven't read about the oracle trigger for a long time, I will review the trigger through two simple small examples here for memo. 1. Case

ORA-01461 troubleshootingORA-01461 troubleshootingORA-01461: can bind a LONG value only for insert into a LONG columnThe connection pool of weblogic is used, and there is no problem.Switch to tomcat or direct jdbc call, and an error is

Oracle learning suggestions Learning Oracle is a long and arduous process. If you are not interested but forced to learn, it is difficult to learn well. To a certain extent, if you want to further improve your knowledge, you have to get in touch