Oracle

Article source home/database/oracle Database Online Documentation 11g Release 2 (11.2)/Database administration http://docs.oracle.com/cd/E11882_01/server.112/e40540/intro.htm#CNCPT001 Oracle Database Introduction Schema In

1.Oracle provides privileged users, such as SYSDBA or Sysoper, who are primarily used to perform maintenance operations on the database, such as starting a database, shutting down a database, establishing a database, and performing operations such

SQL syntax Exercise: 1, select all employees in department 30 select * from EMP where deptno=30;2, lists the clerk's name, number and department number select ename, empno, deptno from Empwhere job=u Pper (' clerk '); 3, find the employee with a

I. Naming rules for table and column names1), must start with a letter2), length cannot exceed 30 characters3), cannot use Oracle's reserved words4), can only use the following characters a-z,a-z,0-9,$, #等Ii. Types of data1), character classChar has

Packages are used to logically combine procedures and functions, which consist of package specifications and package bodies.1), we can use the Create Package command for creating packages such as:I, create a package sp_packageII. Declare that the

First, create a userOverview: In Oracle, to create a new user using the Create USER statement, you typically have DBA (database administrator) permissions to use.Create user username identified by password;Note: Oracle has a problem, the password

Quote this big: Http://www.cnblogs.com/lovemoon714/archive/2012/02/29/2373695.html 1. Why should I use the package? A: In a large project, there may be many modules, and each module has its own procedures, functions and so on. And

Quote this big: Http://www.cnblogs.com/lovemoon714/archive/2012/02/29/2373780.html 1. Concept and use Similar to a custom type in C, you can use it to define a field collection for a table.Defines the format type Recordname is Record

Summary: Virtual columns can be used for special occasions, essentially similar to function columns (that is, the columns already in the table are computed by the function), "The virtual columns are not stored in the database and are returned to the

The connection database suddenly appears with the following exceptionThe following are the solutions that record the following1, check the user's proifle is which, is generally default:Sql>select username,profile from Dba_users;2. View the password

SQL Code 123456789101112131415161718192021st22232425 There is a table named TB, field segment named Name, data type nchar ( -).1. Assuming that the field data is empty, you can do it directly, regardless of the field type you

SQLLDR: Generally used to import files ending with any suffix, this time I was just trying to import a file with a suffix of. 20160101.Combined with the use of input.ctl, can be used under DOS, you can import hundreds of thousands of, millions of

In OracleYou can use the InStr function to judge a string to determine whether it contains the specified character.Finds the specified character in a string, returning the position of the specified character that was found.Grammar:InStr

In the Oracle database, sometimes the ALTER SYSTEM kill session ' sid,serial# ' is used to kill a session process, but after the session is killed with this SQL statement, the database does not immediately release the associated resources. Sometimes

Note: This article does not enumerate all the differences between the two, but in the actual application found in the different function points or processing mode, the reason is recorded, is to remind themselves, do not forgetGROUP BY:(1) Oracle,

Turn characters in Oracle: To_char ()Date of change in Oracle: To_date ()The turn character in MySQL: date_format (date, '%y-%m-%d ') is equivalent to To_char () in OracleDate of transfer in MySQL: str_to_date (date, '%y-%m-%d ') equivalent to

Oracle Issue ORA-12560TNS: Protocol Adapter errorThere are three reasons why the Ora-12560:tns: Protocol adapter error is a problem:1. The monitoring service is not up. Windows platform: Start---program---management tools---services, open the

First, view the constraint information1. Use data dictionary user_constraints to view constraint information for a table in user modeSql> Select Owner,constraint_name,constraint_type,table_name2 from User_constraints;The above SQL statement can

Let's talk about the difference between in and not in, exists and not exists in SQL. sqlexists 1. in and exists In is a hash connection between the external table and the internal table, while exists is a loop on the External table. Each loop then

Oracle cascade query and Oracle cascade QueryThere is a method in ORACLE Database for cascading QuerySelect *// The field to be queriedFrom table// Table with child and parent contact IDSStart with selfid = id// Specify a startid (the Field name is