Oracle

The Sys_connect_by_path function in Oracle is a very important function, and here is an example of using the Sys_connect_by_path function, as follows:Data preparation:1 Create TableTest (Avarchar2(Ten), bvarchar2(Ten)); 2 3 INSERT intoTEST (A,

Many application scenarios, in order to prevent the occurrence of disasters, to protect against the loss of important data, remote disaster recovery solution level is not poor. Then the database will undoubtedly become the focus of the protection of

Create or Replace procedureProc_p_abc isV_sumday Number:=0; I Number:=0; V_calendar_date Number:=NULL; V_day Number:=NULL;begin SelectTo_date (To_char (Sysdate,'RRRR'),'yyyy')-To_date (To_char (Sysdate,'RRRR')-1,'yyyy') intoV_sumday fromdual;

1. First we can log in to Oracle as SYSDBA as a Scott user.Conn Scott/tiger as sysdba2. Then I'll be able to create the user.Create user Zzg identified by zzg123; 3. Create a good user we can then modify the user's password.Alter user ZZG identified

To query all table spaces in the library:Select Tablespace_name from Dba_tablespaces;Select Tablespace_name from User_tablespaces;Query the table space used:Select distinct tablespace_name from Dba_all_tables;Select distinct tablespace_name from

Today in the company encountered a paged query bug, query the first page can query to the data, the following also shows no problem! When I query the second page, the display has finished loading, but the page is not a problem!Debug debugging, found

This article for the learning process of personal experience and summary, non-authoritative, only for reference sharingOracle database, currently one of the mainstream databases, why is one of the mainstream database, there are some mainstream

Oracle's EXP/IMP command is used to implement export/import operations to the database; the EXP command is used to bring data from the remote database server to the local, generating a. dmp file; The IMP command is used to import local database. dmp

Oracle executes external files:C:>sqlplus user/[email protected]sql> @new. sqlExecute multiple SQL files:1. Place all the files in the same directory and execute the command at the command line:c:>dir/b > D:/1.sqlAll the SQL file names are exported

--View tablespace names, path, size, and usage of data filesSelect B.tablespace_name "tablespace name",B.file_name "Data file path",b.bytes/1024/1024 "Size (M)",SUBSTR ((B.bytes-sum (NVL (a.bytes,0))/(b.bytes) *100,1,5) "Utilization"From

The WITH query statement is preceded with a, which is equivalent to building a temporary table before the query, the specified query results are stored with the temporary table, and can then be used more than once for further analysis and processing.

/*divided into four steps*//*1th Step: Create a temporary table space*/Create Temporarytablespace slfph_temp tempfile'D:\oracledata\slfph_temp.dbf'size 50m Autoextend on Next50m maxsize 20480m extent management local;/*2nd Step: Create a data table

Use rules for using keywords in Oracle:1. The query must be an equivalent connection.2. The columns in the equivalent join must have the same name and data type.There are a few things to keep in mind when simplifying connections with the Using

Recently the company's pan-micro OA can not access, Oracle database can not start normally, tried a lot of methods, finally solved, first of all, to talk about the basic situation, I hope to meet the same problem of friends to bring a little

Oracle Servers (Oracle server) are comprised of instances and databases. The example is the so-called Relational database management system (relational Management System,rdbms), which is used to provide relevant database management functions, and

Introduction to several big object data types in oracle databases, oracle Data Types We know that in oracle databases, the maximum length of the field type that can store character-type data type varchar2 is 4000. In actual business, we often

Oracle Multiplexing Control file backup (Code instance), oracle multiplexing 1. view the current control file Show parameter control_files; select name from v $ controlfile; 2. Modify the control_files parameter in the initialization parameter

After Deepin15.5 is restarted, use the DataGrip to visually operate the Oracle database. This article undertakes Deepin 15.5 to use the DataGrip to visualize Oracle databases. It was originally intended to be posted after this article. However,

Relationship between PDB, CDB, and users in Oracle12c, oracle12cpdb CDB: CDB is called the Container Database and the Container Database. (Public users) PDB: PDB is called Pluggable Database, which is Pluggable. (Local User) Link example: We

Oracle 11g R2 for Win7 flagship installation tutorial, 11gwin7 Oracle is a large software company in the United States. It has very powerful functions and is the world's top Enterprise Company. It is essential to learn oracle and be proficient in