Oracle

9: replace in with exists.Important Case: Search for the dept_1 Department employee name 9. 1 SQL statement -- Subquery Select Pname From T_person Where Deptid In ( Select Deptid From T_department Where Deptname Like ' Dept_1 ' ); --

Oracle 11g Standard Edition Correct flashback execution method: SQL> Shutdown; SQL>Startup Mount; the database is started under Mount. SQL> Alter Table Sy_global_nameEnable row movement;--This means that Oracle is allowed to modify rowid.

1. trunc (for dates) The date value intercepted by the trunc function for the specified element. The syntax format is as follows: Trunc (date [, FMT]) Where: Date: A date value. FMT date format, which is truncated by the specified Element

Eg: Related parsing: Table t_pi_part field ID code namevalue 1 222 avalue 2 222 bvalue 3 333 C add a row mark to the part code with the same code and sort select P by ID. *, row_number () over (partition by P. code Order order by. id DESC) as

1. What is a stored procedure. A stored procedure is a section of the database server.ProgramIt has two types. A SELECT query is used to retrieve data. The retrieved data can be returned to the customer in the form of a dataset. The other is similar

Today, a group of friends asked what is instance and database. So the Group of Friends said a lot of things that are very theoretical and theoretical. There are a lot of things online. If the questioner can understand them, he will not ask us.

The control file is a very important file. Only when the instance reads the control file can it be mounted. One principle of DBA is multi-channel control files. Today I did an experiment and learned this. CodeAs follows:

This week was very calm and there was no customer disturbance. A while ago I wrote something about data table compression. Now I feel it is a good way to compress the data and migrate it directly. The following table is available: Create

1 Select 2 B. File_id File ID, 3 B. tablespace_name: name of the tablespace, 4 B. bytes / 1024 / 1024 | ' MB ' Number of bytes, 5 (B. bytes - Sum (Nvl (A. bytes, 0 ))) / 1024 / 1024 | ' MB ' Used, 6 Sum (Nvl (A. bytes, 0

Tablespace Create a tablespace SQL> Create tablespace EMP 2 Logging 3 datafile '/Oracle/oradata/DBA/EMP. dbf' size 5 m extent 4 Management local; Increase the tablespace size SQL> alter tablespace EMP 2 add datafile

In the Oracle-MSSQL Convert tips (1) I already mentioned several tips that used very often. Today's project contains too much views, stored procedures and trigger and the lines of these code are big. So I try to find some tools to validate the

PL/SQL does not use arrays. Its set data types are similar to those of arrays. In versions earlier than 7.3, there was only one set, called PL/SQL tables. After that, there were two sets of data types: Nested tables and varray. The number of

An Oracle Database snapshot is a table that contains query results for one or more tables or views on a local or remote database. That is to say, the basic principle of a snapshot is to save a query result from a local or remote database in a table.

These days I maid a project to convert SQL statements between Oracle and MSSQL and learn a lot. 1. Auto increament column issueSQL Server: When create table define this column property identity (0, 1)Oracle: Must use a sequence and a trigger as

Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--> -- View Oracle version Select   *   From V $ version; /* DDL database definitionDML Database ManagementDCL Database ControlGrant +

From: http://www.easyora.net/blog/oracle_read_write_separated_architecture.html Read/write splitting is an important concept in the distributed architecture. The overall processing capability of many systems cannot be synchronized with the growth

Create procedure [DBO]. [sp_getpaginglist] (@ Table nvarchar (1000), -- table name@ Field nvarchar (1000) = '*', -- read the field@ Where nvarchar (500) = NULL, -- where Condition@ Groupby nvarchar (500) = NULL, -- Group@ Orderby nvarchar (500), --

Original Author: blog garden Yihui original text: Link ForDBAFor example, databaseJobI am not familiar with this because it is often necessary for the database to automatically execute some scripts, back up the database, refine the data, or

 --Full import and export of databases in Oracle: cmd command line mode thanks to clown _ shipping time: Source: tutorial Importing and exporting Oracle Data imp/exp is equivalent to restoring and backing up ORACLE data. The exp command can export

Sqlplus operations Bind variables to SQL * Plus:SQL> variable X number;SQL> Exec: = 7788;SQL> select empno, ename from Scott. EMP where empno =: X;SQL * Plus is a tool provided by Oracle. It can be used not only for testing and running SQL