Oracle

Oracle USER-related data dictionary: USER, ALL, and DBA. USER _ *: information about the object owned by the USER, that is, information about the object created by the USER www.2cto.com ALL _ *: information about the object that the USER can access,

1. The most common one is update t1 set B = (select B from t2 where t1.a = t2.a). However, pay attention to the impact of null values. If you are afraid of the impact of null values, update t1 set tname = (select sname from t2 where t1.id = t2.id)

Plsql cannot connect to the oracle server in linux. Recently, when the company was down, it was found that after oracle data and listening programs in linux started normally, plsql on the client still could not connect to the server, ORA-12514 error

In oracle, the single quotes in oralce are escaped. strings are referenced by single quotes, and the escape is also completed by single quotes. This is a headache for many beginners, especially those who are learning dynamic SQL. In simple single

Oracle 10g rac listener name: CRS-0210: cocould not find resource problem want to restart the listener, The results found that the [oracle @ node1 ~] $ Srvctl stop listener-n node1CRS-0210: cocould not find resource ora. node1.LISTENER _ NODE1.lsnr.

Time-based backup retention policy rman study 1 Experiment Preparation a) physical and logical checks [SQL] SQL> col file_name for a70 wrapped SQL> select file_name, status from dba_data_files where file_id = 4; FILE_NAME STATUS certificate ---------

Overview of Oracle default users when installing the Oracle database, Oracle will automatically create a group of users who can log on to and manage the database: username initial Password Logon identity descriptionSys change_on_install sysdba or

Oracle client configuration 1. copy the client file and copy the instantclient_11_2 folder to a directory. I put it on drive D directly. 2. configure the client environment variable TNS_ADMIND: \ instantclient_11_2 3. configure the sid file

Oracle RAC connects to a specified instance. In some specific cases, you sometimes need to connect to the specified instance in RAC from the client, instead of dynamically selecting the client Load_balance or forwarding it based on the load

1. Find the oracle Installation Package and unzip it to the database directory./runInstaller www.2cto.com Do not fill in the oracle support account, and then select "do not receive" in the pop-up window, Continue www.2cto.comSelect to only install

The RETURNING into statement can be specified in the DML Statement of ORACLE. It is easy to use, and it is not much different from the select into statement. The use of RETURNING statements can simplify PL/SQL programming in many cases. DELETE

Oracle dataguard configuration Oracle dataguard Configuration System linux Description: master server ora10g01 (192.168.1.252) Standby server listen 10g02 (192.168.1.253) both machines are installed with the same version of the database master

Oracle query does not repeat multiple columns of SQL statements. In Oracle, it is required to query t in the customer table. address, t. customer_name does not repeat columns: the general idea is: SQL code select distinct t. address, t.

Oracle SQL converts a varchar type data into multiple rows of Results records. Today, when I create a report, I want to use an SQL query to query the final results. However, I encountered some problems during implementation, one field I found is

Oracle-based user management 1. oracle-Based Default users sys change_on_install [as sysdba] system manage scott tiger 2. start listening lsnrctl start listening name in cmd (default listening name is not writable) 3. Start the instance

You can use user_table_column to check whether the data of a specified field in the Oracle query table contains a specific character. www.2cto.com the main fields in this view are described as follows: TABLE_NAME table, view, or Clusters name COLUMN_

The use of the case end and decode functions in the select clause can be implemented using the case end and decode functions to compare the size of the Field Values in the select clause of the Oracle database. For example, www.2cto.com queries the

In oracle, tables like BIN $ MrkCYT9eTTK + 0sStMwn7 + Q = $0 are not deleted from oracle10g, but stored in recyclebin, in this process, files deleted in windows will be temporarily stored in the recycle bin. The system will automatically rename the

Common SQL statements for Oracle Database permission management 1. Three default users in Oracle9g: www.2cto.com username and password sys change_on_install [as sysdba] system manager scott tiger 2. User Logon 1) enable listening C: \ Users \

Oracle sets the IP address for database access. oracle Server 192.168.1.9 Linux www.2cto.com oracle client 192.168.1.6 Windows192.168.1.6 tnsping 192.168.1.9Bat code Microsoft Windows [version 5.2.3790] (C) Copyright: 1985-2003 Microsoft Corp. c: \