Oracle

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.

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

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

Oracle Execution Plan There are 5 types of index scans, depending on the type of index and where constraints: Index unique scan (index unique scan), indexed range scanning (index range Scan), index full scan Full scan), Index quick Scan (index fast

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

--View User system permissionsSELECT * from Dba_sys_privs;SELECT * from User_sys_privs;--View User object permissionsSELECT * from Dba_tab_privs;SELECT * from All_tab_privs;SELECT * from User_tab_privs;SELECT * from Dba_roles; --View all roles--View

There are a lot of tutorials on plsql connections, the most important of which is the listener and tnsnames two files under D:\oracle\product\10.2.0\db_1\network\ADMIN. After repeated modification and testing, finally succeeded.Listener file:#

(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

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

Oracle Database Import and Export, oracle Database Export The import and export of Oracle databases is an important technical activity, which not only solves the import and export of databases, but also facilitates and quick data access. Use imp

[Book Reviews: Oracle query optimization and rewriting] Chapter 4: book reviews oracle [Book Reviews: Oracle query optimization and rewriting] Chapter 4 BLOG document structure I. 1 Guide After reading this article, you can master the following

Oracle cursor and temporary table usage exercises 1. Create a session-level temporary table:   create global temporary table pact_test( pact_id varchar2(100), pact_code varchar2(100), pact_name varchar2(800)) on commit preserve rows;   2.