Oracle

5.oracle dump understanding five data block theoryWelcome reprint, Reprint please indicate source: http://blog.csdn.net/notbaron/article/details/51228514The first two articles describe what we see at the operational level, but without theoretical

First, the Oracle database installed on the computer, the installation of Oracle database in common sense, the direct download of the installation is OK, but midway is a problem, because my system is Win7 the client clients of Oracle does not

Oracle View Current User informationFirst, view the current user information:1. View the current user-owned Role Permissions information: SELECT * from Role_sys_privs;2. View the details of the current User: SELECT * from User_users;3. View the

Server System for Windows R2 64-bit, because the C disk space will be full, to the C-disk of the Oracle DBF data file to migrate to the D disk, the steps are as follows:1. Enter CMD to start the Cmd.exe window2. Enter Sqlplus/nolog3. Input conn Sys/[

You can also use PL/SQLCreateDirectory "image" as 'e:\';--"image" to bring double quotes, many online without, I test error, and, ' E:\ ' is the server directory, non-local directory. User Authorization required: Grant create any directory to

The main contents of this article are as follows:1. Trigger type1.1 DML triggers1.2 Alternative triggers1.3 System triggers2. Trigger composition3. Create a Trigger3.1 Trigger Trigger Order3.2 Creating a DML Trigger3.3 Creating an alternative

1Installation Environment Install the database software on the Primary Library, and build the monitoring and instance, install the database software on the Standby Library, and build the monitoring, but do not build the instance.

Content from: Oracle®database SQL Language Reference 11g Release 2 (11.2) e41084-03.The Empolyees table is from the HR scenario. The rank function calculates the position of a value in a particular sort (using the aggregation syntax) and

SQL statement for querying and deleting duplicate records1, look for redundant records in the table, duplicate records are based on a single field (Peopleid) to determineSELECT * from Peoplewhere Peopleid in (select Peopleid from People GROUP by

Some simple command comparisons for Oracle and MySQL1) sql> Select To_char (sysdate, ' Yyyy-mm-dd ') from dual;Sql> Select To_char (sysdate, ' Hh24-mi-ss ') from dual;Mysql> Select Date_format (now (), '%y-%m-%d ');Mysql> Select Time_format (now (),

I. Conceptual interpretationTopology Manager is primarily used to manage the following 5 categories of tasks and store the information in the master repository for shared use by all modules.Physical Architecture: Define various technologies

/DEV/SHM The Oracle instance should be set to start without reporting ORA-00845From: Ora-00845-which value FOR/DEV/SHM is needed to startup database without ORA-00845 (document ID 1399209.1)Suitable for:Oracle Database-standard edition-version 11.1.0

1. Absolute value: ABS ()Select ABS ( -2) value from dual;2. Rounding function (Large): Ceil ()Select Ceil ( -2.001) value from dual; (-2)3. Rounding function (small): Floor ()Select Floor ( -2.001) value from dual; (-3)4. Rounding function

Oracle Loop statementsWhen you write a loop control structure, you can use three types of loop statements, such as the basic loop, while loop, and for loop, which describe the methods for using these three loop statements.1. Basic cycleLOOPStatement1

First, login issues1, forget the user name password:(1) Default User name password:System/manager Sys/change_on_install Scott/tiger(2) CMD log in as a system administrator:C:\users\samsung>sqlplus System/manager as SysdbaView all User:Sql> select

Go from Network1. NESTED LOOPThe nested loop connection is a good choice for cases where the subset of data being connected is small. Nested loop is to scan a table, each read to a record, according to the index to go to a table to find, no index is

 when connected to a local Oracle, it is generally okay. Both the Sqlplus and OCI are native Oracle-brought from. (Settings: Tools, Options->oci)the following

Oracle client connection remote Oracle service Chinese garbled problem, oracle Chinese When the local machine remotely connects to the remote Oracle service, the following retrieval statement is written: Select * from sys_employee Chinese garbled

Oracle Database sorts null values and the difference between mull and null strings. oraclemull Processing of null values in order by sortingWhen sorting business data, it is found that some field records are null values, and then there is a data

Oracle service cannot be started. If Windows cannot start OracleOraDb10g_home1TNSListener, error 1067: Unexpected Process Termination ., Run the Net Configuration Assistant in the Configuration and transplantation tool to configure the listener.