Oracle

Line 1:Create OR REPLACE PROCEDURE is an SQL statement that notifies the Oracle database to create a stored procedure called skeleton, overwriting it if it exists;Line 2:The IS keyword indicates that a PL/SQL body is followed.Line 3:The BEGIN

--==cmd Console ==----== Daily User Management sql==----Connect to Sqlplus>sqlplus/nolog--Connect as DBASql>conn/as SYSDBA--Modify the user password to modify the system user's password to systemSql>alter user system identified by

Original address Oracle Declaration constantsConstants are given an initial value when declared, and are not allowed to be re-assigned at run time. declare constants using the constant keyword. Declaring constants1 DECLARE2 PiCONSTANT Number:=3.

Transferred from: http://www.cnblogs.com/tippoint/archive/2013/04/07/3003810.htmlIn some cases, we need to modify the host name of the Oracle database that is already installed. Here are the steps1. Modify/etc/hostsSu-Vi/etc/hosts2. Modify NetworkVi/

CREATE TABLE STUDENT (--Creating student tablesID Number (TEN) PRIMARY key,--primary Key IDSNAME VARCHAR2 (20),);You must specify an ID when you add data to the student tableINSERT into STUDENT VALUES (1, ' Tom ');The following combination of

Ora-00257:archiver error. Connect internal only, until freed. Cause:the archiver Process received a error while trying to archive a redo log. If the problem is not resolved soon, the database would stop executing transactions. The most likely cause

Inside connection: Is our normal table connection, display ID match dataSELECT *  fromA,bWHEREThe a.aid=b.bid only takes out the matching data. Outer joins: Divided into left and right connectionsLeft join: First remove the left table (a table) data,

Originally from Techfox It Technology Forum1. Processing in block: However, PL/SQL code can only handle data up to 32K, which exceeds this limit and cannot be processed by PL/SQL. Sql> SET Serverout on Sql> BEGIN 2 for I in (SELECT

One, the current timeUse the Sysdate function directly in SQL to represent the current time.So, using the current time, we can get the time information specified before and after the current time.1.1 Plus SubtractionSelectSysdate-1 fromdual;-- --

1. Character data type (Char,varchar2,long)CHAR: To store an alphanumeric value, the column length of this data type can be between 1 and 2000 bytes. If not specified, it consumes one byte by default, if the user enters avalue is small at the

Sys_guid ()-Unique indexIn Oracle, you can use Sys_guid () to generate a GUID that is equivalent to NEWID () in MSSQL.The resulting data in oracle9i and Oracle 10g is 32 bits, such as: 234E45F0077881AAE0430AA3034681AAHowever, the GUID in Oracle is

In order to facilitate learning and testing, all of the examples are created under the Oracle's own user Scott.Note: The red Order by in the title indicates that you must bring an order by when using this method.Rank ()/dense_rank () over (partition

DECLAREV_sqlVARCHAR2( +); V_sql_headVARCHAR2( -); V_sql_tailVARCHAR2(Ten); V_dayVARCHAR2(8); CURSORC_cur is SELECTTo_char ((To_date ('2012-01','yyyy-mm')+(ROWNUM- 1)), 'YYYYMMDD') S_date fromDUAL CONNECT byROWNUMLast_day (To_date ('2012-12','yyyy-mm'

(Reprinted) TNSPING command, reprinted tnsping command Oracle Net tool (command) tnsping is an OSI Session Layer tool used: 1) Verify the name resolution (name resolution, of course, the name of the oracle Network Service) 2) whether the remote

Misunderstanding of Oracle parallelism 2: locking the entire table I have written a misunderstanding about Oracle parallelism before. 1. In fact, you didn't use parallelism. I always thought that Oracle would only lock the data to be modified. But

Oracle cascading deletion trigger and oracle trigger Create table student (-- CREATE a STUDENT TABLEId number (10) primary key, -- PRIMARY KEY IDSNAME VARCHAR2 (20 ),CLASSNAME VARCHAR2 (20) -- class ID ); Insert into student values (1, 'Tom ', 1

Oracle tables cannot be DDL or stored in a stored procedure. In the process of data migration, we will face two common hang scenarios: 1. You cannot modify or increase the length of a field in a table. 2. stored procedures cannot be

Export oracle comments and oracle comments Indicates that a user has a comment + Table comment + field details + field comment select ATC.OWNER, atC.TABLE_NAME, utc.comments, ATC.COLUMN_NAME, ATC.DATA_TYPE,

The SQL query result set is sorted by specified conditions. Oracle considers null to be the largest. Sort in ascending order. By default, the null value is placed behind. Sort in descending order. By default, the null value is ranked first. There

Create a tablespace in an Oracle database and an oracle database -- Create a tablespace in the Oracle database Create tablespace new_taspace -- Tablespace name DATAFILE 'd: \ NEWTABLESPACE. dbf' -- the data file and location associated with the