Oracle

--==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.

CREATE TABLE STUDENT (--Creating student tablesID Number (TEN) PRIMARY key,--primary Key IDSNAME VARCHAR2 (20),CLASSNAME VARCHAR2 (20)--Class ID);INSERT into STUDENT VALUES (1, ' Tom ', 1);INSERT into STUDENT VALUES (2, ' Jack ', 1);INSERT into

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

1. Basic StructureCREATE OR REPLACE PROCEDURE Stored procedure name(Parameter 1 in number,Parameter 2 in number) isVariable 1 INTEGER: = 0;Variable 2 DATE;BEGINEND Stored Procedure Name2.SELECT into STATEMENTStoring the results of a select query in

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

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

(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

How Does Oracle Randomly Read values from a specific combination? Here, we will use the DBMS_RANDOM package and the case when statement as follows: 1. Use the DBMS_RANDOM.RANDOM function to randomly generate a value and then modulo the value. If we

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