Oracle

System Environment:1. Operating System: Windows 2000 server,2. Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition3. installation path: C: \ oracle Error:A data file in the database was accidentally deleted due to misoperations,The

From http://blog.chinaunix.net/space.php? Uid = 16981447 & Do = Blog & cuid = 430716 was simply formatted and a little original stuff was added. Oracle9i introduces the merge command. You can execute the inserts and updates operations on a table in

Oracle 11g New Features 09-10-10Oracle 11g new feature: Rman backup skips the free interval 09-10-10Oracle 11g new feature: Server Result Cache Test 09-10-10Oracle 11g new feature: One of Result Cache 09-10-10Oracle 11g new feature: determining

After installing oracle in the notebook, you can use the OEM console normally. However, after logging out, log on again or restart the system, or change the network environment of the notebook, problems may occur. The solutions to these problems

Reading Notes db file scattered read DB, db file sequential read DB, free buffer waits, log buffer space, log file switch, log file sync The view v $ session_wait can be used to view the current wait events of the system and the information about

PL/SQL "ORA-14551: cannot perform DML operations in queries" solved the environment Oracle 11.2.0 + SQL Plus problem by writing a function according to the following requirements. in the emp table, the total number of employees whose salaries are

Oracle 11 Client installation and PLSQL and TOAD Chinese garbled solutions 1. Download the "Instant Client Package" software from Oracle, which provides a better solution for Oracle Client greening. Is: http://www.oracle.com/technology/software/tech/

Configuring the Oracle 11g Data Guard (logical standby) Oracle Data Guard logical standby database based on the same host uses a backup of the master database to first create a physical standby database, then convert it to a logical standby database.

SQL CREATE VIEW statementWhat is a view?In SQL, a view is a visualized table based on the SQL statement result set. A view contains rows and columns, just like a real table. A field in a view is a field from a real table in one or more database

Check whether the oracle database is in archive Mode SQL> select name, log_mode from V $ database;NAME LOG_MODE------------------------------------------TEST NOARCHIVELOGSQL> archive log listDatabase log mode No Archive ModeAutomatic archival

Addition Select sysdate, add_months (sysdate, 12) from dual; -- add 1 yearSelect sysdate, add_months (sysdate, 1) from dual; -- add JanuarySelect sysdate, to_char (sysdate + 7, 'yyyy-mm-dd HH24: MI: ss') from dual; -- add 1 weekSelect sysdate,

After installing oracle in the notebook, you can use the OEM console normally. However, after logging out, log on again or restart the system, or change the network environment of the notebook, problems may occur. The solutions to these problems

The distinct keyword can only be used to filter all records in the query field that are the same (the record set is the same). If you want to specify a field, it does not work. In addition, the distinct keyword is sorted, Which is inefficient.Select

Last week, I wrote an article on connecting the oracle client to the server, solving the troubles of installing it in my own book. In the past, my computer and server were in the same LAN, so every time they were remote servers, they were not the

1. create and manage tables1. Create Table syntaxCreate table Name (column datatype [default expr] [, column...])Default Constraints2. Create a table using subqueryCreate table NameAsSelect * from u tableIi. modify a table1. Add a new columnOracle:

SQL> show all -- View all 68 system variable valuesSQL> show user -- display the current connected userSQL> show error -- Display errorSQL> set heading off -- disable the output column title. The default value is ON.SQL> set feedback off -- disable

If you have a cold backup, but one of the data files is missing, but you have all the archives, if you want to restore the data files, you can refer to the following example:Copy codeThe Code is as follows:[Oracle @ jumper eygle] $ sqlplus "/as

ABS (x) function, which is used to return the absolute value of a number.ACOS (x) function returns the arc cosine of X. X ranges from 1 to-1, and the input value ranges from 0 to pie, in radians.The ASIN (x) function returns the arc sine of X. X

Scalar Data TypeScalar data types have no internal components. They can be divided into the following four categories:. Number. Character. Date/time. BooleanTable 1 shows the numeric data type, table 2 shows the character data type, and table 3

The ORACLE tutorial is: naming rules for Oracle database management scripts. The data dictionary in Oracle is a very important part of the database and provides information about the relevant database. It is used by all Oracle users (from