Oracle

SQL code--Get the current SCN Copy Code code as follows: Select Dbms_flashback.get_system_change_number scn1, TIMESTAMP_TO_SCN (sysdate) scn2 from dual; --Convert the SCN to successful time Copy Code code as follows:

This article content B-tree (B-tree) hashing (hash) k-d tree (k-d) dot four fork tree (Point Quadtree) This article describes the structure of the Oracle index. Understand the data structure at the bottom of the Oracle index to better understand

1), check the cluster status: [GRID@RAC02 ~]$ crsctl Check Cluster Crs-4537:cluster Ready Services is online Crs-4529:cluster Synchronization Services is online Crs-4533:event Manager is online 2, all Oracle instances-(database state): [Grid@rac02 ~

Plsql Connect Oracle Database ora 12154 error Today encountered a problem, using Sqlplus can connect to the remote database, but the use of plsql but not connected, error "ORA-12154:TNS: Unable to resolve the specified connection identifier" The

I have a strange question today:Use Sqlplus on the client to log on as a normal user, but neither system nor SYS users can log on, prompting Ora-12154:tns: Unable to resolve the specified connection identifierSql> Conn System@webdataEnter

Oracle has many locks, and the utility of various locks is not the same. Oracle row-level locks are highlighted below, and Oracle row-level locks lock only the rows that the user is accessing. Can better guarantee the security of the data. If the

? Class Db_sql { var $Debug = false; var $Home = "/u01/app/oracle/product/8.0.4"; var $Remote = 1; /* This Query is sent directly after the ' the ' Example: var $ConnectQuery = "ALTER session SET Nls_date_language=german nls_date_format= ' DD." Mm.

1. The case-when expression has two forms Copy Code code as follows: --Simple Case function Case Sex When ' 1 ' THEN ' male ' When ' 2 ' THEN ' woman ' Else ' other ' end --case search function Case When sex = ' 1 ' THEN

Import Java.io.BufferedOutputStream;Import Java.io.ByteArrayInputStream;Import java.io.IOException;Import Java.io.InputStream;Import Java.io.OutputStream;Import Java.io.Reader;Import Java.sql.Clob;Import java.sql.Connection;Import Java.sql.ResultSet;

The syntax structure of the DECODE function is as follows: Copy Code code as follows: Decode (expression, search_1, result_1) Decode (expression, search_1, Result_1, search_2, result_2) Decode (expression, search_1, Result_1,

The content of this article• Software Environment• Simple demonstration of Oracle database concurrency causing row-level locksThis article provides a simple demonstration of row-level locks that are caused by concurrency for table primary keys.

Accidentally heard of the Oracle database snapshot, the word I had a listen to be stunned, do not know what this is, and then spent a little time to study the next, the following is my summary of learning through the network Snapshots are primarily

1. Query table Space usage: Sqlplus System/manager@topprod Copy Code code as follows: Sql> @q_tbsFREE 2. Query Temp Use method: Sqlplus System/manager@topprod Copy Code code as follows: Sql>select

Scott user's password is not correct, enter administrator user, modify Scott user password can or modify the password like this: In the Run Bar Knock: Sqlplus (space)/nolog carriage return Then knock in the pop-up box: Conn Sys/password as SYSDBA

Installation steps: I. Installation of oracle-instantclient Download Address: http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html Download oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm

The examples in this article describe the Java-derived classes for MySQL and Oracle links. Share to everyone for your reference. as follows: Import java.sql.Connection; Import Java.sql.DriverManager; Import java.sql.SQLException; public class

I. Import an Excel file using the PL/SQL Import Tool 1. Open PL/SQL and click T00ls->odbc in the menu bar Imtorper, open the ODBC Importer option box; 2. In the Data fromodbc page, select the format of the file you want to import, and select

(summary) Oracle monitoring service LSNRCTL parameters and query statusLsnrctl command Common parameters in detail: LsnrctlStartStart the specified listener StopClose the specified listener StatusDisplays the status of the listener. The

--View Current User select Username from dba_users;--Creating a temporary create USER GZMPC identified by PASSWORD;--authorizing Grant CREATE SESSION to GZMPC; CREATE tablespace gzmoc_wk datafile'Gzmoc_wk.dat'SIZE 10M autoextend on; CREATE temporary

Directory + 1. Overview of database Security control policies + 2. User Management + 3. Resource Restriction and password management + 4. Rights Management + 5. Role Management + 6. Audit 1. Overview of database Security control policies Security