Oracle

In the process, especially the tasks performed daily, usually to check that the query's data table exists, if it does not exist and wait for a period of time to execute, the following code implements this function, if the table does not exist, throw

One: Install Oracle client on sqlserver2005 server, run NETCA create TnsnameSecond: Fill in as shownWhere the first line is filled inSecond, three lines: fill in the diagramLine four: Fill in the Tnsname650) this.width=650; "style="

Create or replace procedure Prc_get_sex(Stuname Student.name%type)AsStusex Student.sex%type;BeginSelect Sex to Stusex from student where name=stuname;Dbms_output.put_line (' Students ' | | stuname | | ' The sex is: ' | | Stusex);exceptionWhen

Oracle restores data from a table to a point in time OraclesqlExecute the following SQL to restore data from the Test_temp table to 2011 04 29 11:06:00Note that it is important to delete all data first, otherwise it may result in duplication of

1. Querying partial field properties of a tableSelect T.*, c.comments from user_tab_columns T, user_col_comments c where t.table_name = C.table_name and t.colum N_name = C.column_name and t.table_name = ' El_lesson ' and T.column_name in ('

In the project development, sometimes use multi-table query, there are many methods, such as correlation, such as views, but for the query, view query is the fastest, if you have a lot of database field information, the query will have to check the

Display information for all partitioned tables in the database: Dba_part_tablesDisplays all partition table information that the current user can access: all_part_tablesDisplays information about all partitioned tables for the current user:

Monitoring scripts executed by Oracle SQL statements! [@[email protected]]--Find the method for bad sql:SELECT * FROM (select Buffer_gets, Sql_textFrom V$sqlareawhere Buffer_gets >500000ORDER BY buffer_gets Desc) where rownum--Perform the number of

--Refer:--http://www.cnblogs.com/gnielee/archive/2009/09/09/1563154.html--http://www.cnblogs.com/yudy/archive/2012/07/18/2597874.htmlCREATE OR REPLACETYPE Ty_str_split is TABLE of VARCHAR2(4000);CREATE OR REPLACE FUNCTIONSplitstr (p_stringinch

Oracle error highlights: ORA-00119 & ORA-00132 Sometimes, God is joking with you. Yesterday we had a hard time configuring Oracle, so we could use PL/SQL to log on and use it normally. Today we suddenly cannot. And the error is very strange, and no

Basic OracleDDL operations Share with you my learning notes on Oracle Database Definition Language 1. Create Table space syntaxCreate tablespace test -- tablespace nameDatafile 'd: \ oradata \ orcl \ test. dbf '-- data file corresponding to the

Oracle database backup and recovery----------------------- Export Database ----------------------------1. Export the complete databaseExp userName/userPassword file = d: \ database. dmp full = y2. Export the object of a user in the databaseExp

New Feature of oracle11g -- AdaptiveCursorSharing (ACS) 1. ACS Overview Oracle Database 11g provides the Adaptive Cursor Sharing (ACS) function to overcome the possibility of Sharing a Cursor that should not be shared in the past. ACS uses two new

Oracle multi-Table query To query multiple tables, we must first avoid Cartesian sets. To avoid Cartesian sets, the query conditions should not be less than the number of tables-1.1. Display employee name, employee salary, and employee's department:

Getting started with oracle Database Data Query 1. perform operations on data using arithmetic expressions during the Query ProcessThe student table structure is as follows:The last salary represents the monthly salary of each person. Now I want to

(Summary) Oracle 11g Common Management commands (user, tablespace, permission), oracle11g 1. Start the oracle database: Switch from root to oracle:Su-oracle Enter the sqlplus environment. The nolog parameter indicates not to log on:Sqlplus/nolog Log

Modify logon authentication mode in oracle By configuring the sqlnet. ora file, we can modify the oracle login authentication method.SQLNET. AUTHENTICATION_SERVICES = (CNT); operating system-based authenticationSQLNET. AUTHENTICATION_SERVICES =

How do Oracle beginners know common data tables such as EMP, DEPT, and SALGRADE? Graphic operation Oracle Database beginners often mention several common database tables in some books, such as EMP, DEPT, and SALGRADE. Where are these tables

The fifth day of oracle LearningZookeeper 1. Review in the previous section2. maintain data integrity3. Manage Indexes4. manage permissions and Roles 1. Skills in maintaining oracle Data Integrity2. Understand the index concept and create an index3.

Oracle Developer code The following are quotations from Oracle: Oracle Database developers shocould follow is to do everything they can in SQL. what they cannot do in SQL, they shoshould do in PL/SQL. and what they cannot do in PL/SQL, they