Oracle

In Oracle, both command and object names are case insensitive because Oracle converts all names and commands to uppercase when the statement is processed. However, the characters in the string, whether comparison or sorting, are case sensitive. This

The following is from: http://lovexueer.itpub.net/post/5072/49241 December 26 (Monday) Test environment: Os:xp db:9201 This test tests the following conditions: A. Normal shutdown database, database (not) archive, rollback segment table space lost,

Oracle Stored procedures: Grammar:CREATE [OR REPLACE] PROCEDURE procedure_name(Arg1 [Mode1] datatype1,arg2 [Mode2] datatype2,...)is [as]Pl/sql Block;Mode is used to specify the input and output parameters: In is an input parameter, out is an output

In Oracle, both command and object names are case insensitive because Oracle converts all names and commands to uppercase when the statement is processed. However, the characters in the string, whether comparison or sorting, are case sensitive. This

Oracle View trace file step   1. Get current trace file generation path sql> select Tracefile from v$process where addr in (select Paddr from V$se Ssion where SID in (select SID from V$mystat));   Tracefile  www.2cto.com  ----------------------------

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

Oracle/plsql: Primary key (Primary key) usage 1 Goals Examples explain how to create, delete, disable, and open primary keys. 2 Preface-What is a primary key In Oracle, a primary key refers to a single data table column or union of data table

Oracle | Pl/sql Unique index (unique Constraint) usage 1 target Demonstrates how to create, delete, disable, and use a uniqueness constraint with an example. 2 What is a uniqueness constraint. A uniqueness constraint refers to a constraint in a

The purpose of trigger development: to ensure that databases meet specific business rules and enterprise logic, you can use triggers, constraints, subroutines. BecauseConstraints are the simplest and performance, the selected constraints, if the

See this interface, I believe a lot of people will like, this interface is very concise, there is no superfluous things, I think the day-to-day operation can basically meet the requirements of the operation of the database is very convenient, I

type of index:B-Tree IndexBitmap indexHash indexIndex Choreography TableReverse Key indexFunction-based indexingPartitioned indexLocal and global indexes Limit Index ( index invalidation ) The reasons for the failure of Oracle indexes are many:

Keywords: analysis design and modeling Today, the data table, using the Oracle 9i database, with the Powerdesinger 12 model, the concept model into a physical model, I look at the preview, it is strange to find all the drop, create and other

Classification of indexesLogically:Single Column Single-line indexConcatenated multiple rows IndexUnique Unique indexNonunique Non-Unique indexfunction-based Function IndexDomain Field IndexIn physics:Partitioned Partitioning Indexnonpartitioned Non-

Example 1:select deptno,ename,job,sal,sum (SAL) over (order by Sal) his from EMP; Results: SMITH Clerk JAMES Clerk 950 1750 ADAMS Clerk 1100 2850 WARD salesman 1250 5350 MARTIN salesman 1250 5350 MILLER Clerk 1300 6650 TURNER salesman 1500 8150

When you install Oracle, if you do not reset the password for the following users, the default password is as follows: User name/Password login Identity descriptionSys/change_on_install SYSDBA or Sysoper cannot be logged in as NORMAL as the default

1, Ora-12541:tns: No listener Cause: The listener is not started or the listener is corrupted. If the former, use the command net start Oracleorahome10gtnslistener (the name may differ), and if it is the latter, use the "Net Configuration Assistant"

---create a tableCREATE TABLE TestTable(ID1 VARCHAR2 (12),Name VARCHAR2 (32))Select T.id1,t.name from TestTable tInsert into TestTable (ID1, NAME)VALUES (' 1 ', ' Zhangsan ');Insert into TestTable (ID1, NAME)VALUES (' 2 ', ' Lisi ');Insert into

Special symbol ASCII definition Box Drawings Chr (9) Line feed Chr (10) return character Chr (13) Select Replace (replace (' 111111111111 ' | | chr) 22222222222222222 ' | | Chr (a) | |

When you create a new connectionConnection name: Your own casual name (but preferably the same as the project name)User name:Password:Host name: The IP address of the DB file namePort: The port in the DB file nameThe name after the port in the

ORACLE Directory Directory management stepsOracle 's directory is a directory path in the database and needs to be mapped to the corresponding directory in the operating system; The role of the Oracle directory is to make ORACLE database and