Oracle

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 ('

VBA Connection Oracle needs to add references:After that, the connection string is: Provider = msdaora.1; password=******; User Id=xxxxxxx;data source=dbid; Persist Security Info=trueThen use the standard package of ADO, 1, use ado.connection, open

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

1. Use arithmetic expressions to perform operations on the data during queryThe student table structure is as follows:The last salary represents each person's monthly salary, I now want to inquire each person's annual salary:2. Use the NVL function

--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

--Count The length of stringSelectLENGTHB ('SELECT * from Scott.emp') asCountted_by_byte, Length ('SELECT * from Scott.emp') asCountted_by_char fromdual;--for some character encoding, the length () and the LENGTHB () are same in 中文版--feature to

Get information about a tablecan be directly describeDESC[RIBE] table_name;You can use the data dictionarySELECT * FROM User_tableswhere table_name =xxxx; [or WHERE table_name in (' xxxx ', ' xxxx ')]Renaming a tableRENAME Table_old_name to

Http://www.jb51.net/article/42369.htmSql:charindex (' String ', field) >0 charindex (' Administrator ', Muserid) >0Oracle:instr (field, ' String ', >0) InStr (Muserid, ' Administrator ', ") >0In the project, we used the function of INSTR in Oracle,

Generating random data under SQL Server is much more dry, but I'm stupid under Oracle. Not used Oracle, do not know what to do? SQL Server relies on tablesample or checksum (NEWID ()) for random sampling, and Oracle has its own random sampling

One, import. sql file@data. sqlSecond, record the log:1. Enter command sqlplus database name/password @ Database Press ENTER2. Enter spool to specify the path: \a.log Press ENTER (This step is to track the bulk of SQL log, the path to write, as long

The following are Oracle Master quotations: Oracle Database developers should follow is to do everything they can in SQL. What they cannot does in SQL, they should does in PL +. And what they cannot does in PL/SQL, they should do in

The use of the--oracle trunc () function/************** Date ********************/1.select trunc (sysdate) from dual--2013-01-06 today's date is 2013-01-062.select trunc (sysdate, ' mm ') from dual--2013-01-01 returns the first day of the

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:

(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