Oracle

Many applications have similar organizational tables, and the organization's tables are typically hierarchical (no loop nodes). So when organizations control data permissions, many people prefer to get organization information through connect by,

Oracle Kanji Pinyin (get full spell/pinyin initials/Pinyin intercept, etc.)The effect is as follows: Oracle character Set GBK no problem, UTF-8 need to modify SQL code--oracle kanji to Pinyin package--1. Get full spell www.2cto.com SELECT gethzpy.

This error occurs because the hostname and/etc/hosts file are inconsistent, just need to write the hostname and its IP/etc/hosts file, OK.Note that the name cannot be underlinedChange the network file, and then use the hostname command to specify

1. View All Users:SELECT * from Dba_users;SELECT * from All_users;SELECT * from User_users;2. View user or role system permissions (System permissions that are directly assigned to a user or role):SELECT * from Dba_sys_privs;SELECT * from

querying SQL statements that Oracle is executing and executing--query Oracle Executing SQL statement and the user who executes the statement select B.sid Oracleid, B.username Log in to the Oracle user name, b.serial#, spid os ID, PADDR, sql_text

The syntax for creating a function is as follows:CREATE [OR REPLACE] FUNCTION function_name[(argment [{in | Out | In Out}] Type,argment [{in | Out | In Out}] Type]RETURN Return_type{is | As}BEGINFunction_bodyEXCEPTIONOther statementsEND;Cases:1

Select * fromgoods; AChar(Ten):='Samsung' --Fixed length stringBvarchar2(Ten):='Samsung';--variable StringC Binary_integer:='10001';--signed integer, which optimizes performance for integer calculationsD Number(5,2):='123.45';--valueELong

Data import times ORA-12899 error, that is, the length of the inserted data exceeds the set length of the field, the actual length is not long, because of the different Oracle character set, the length of the Chinese characters caused by different.

1. Download the installation packageHttp://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.htmlOracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.zipOracle-instantclient11.2-sdk-11.2.0.1.0-1.x86_64.zipOracle-instantclient11.2-sqlplus-11.2.0.

Environment:os:oel5.6rac:10.2.0.1.0There are rac1 at the moment. Rac2. RAC3 three nodes, the following is the process of deleting the RAC3 node1. Delete The DB instance on the RAC3 node[Email protected] ~]$ dbca-silent-deleteinstance-gdbname

Syntax:SELECT * FROM table_name where DBMS_LOB.INSTR (field name (clod type),' query condition ', ' n ') > 0;Syntax Explanation:In Oracle, you can use the InStr function to judge a string to determine whether it contains the specified character. Its

1, first create the usersyntax [Create users]: Create user username identified by password [i.e. password];Example: Create user zhengxin identified by Zhengxin;2. Giving the User DBA Authority Grant DBA to Zhengxin3. Open cmd command lineSyntax: MP

Data type:Character typeChar fixed length, maximum 2000 charactersvarchar LONG, max 4000 charactersCLOB (character large object) character type large objects, Max 4GNumber TypeNumber Range (10-38 Square to 10 38-square, fractional integer

In order to standardize the relational data model, the relational database system must obey certain rules in the design, which becomes the relational database paradigm. 1. First Paradigm 1NFif the value in the field is already a value that cannot be

 1 Start time and end time of the fetch week The start time of the pick-up week. Start with Monday. Sql>select TRUNC (to_date (' 2013-11-25 10:31:11 ', ' yyyy-mm-dd HH24:MI:SS '), ' D ') + 1 ASA from DUAL;A-----------2013/11/25

Directory1) Basic2) Mathematical functions3) rownum4) Paging5) Time Processing6) Character function7) To_number8) Aggregation function1) Basic--New table:CREATE TABLE table1 (ID varchar (primary) key, name varchar (+) not NULL);--Inserting

First part knowledge preparation1. SQL Execution Process2. SQL sharing3. Binding variables4. Data table access method5. SQL Execution Order6. Index usage　　　　　　　　　　　　　　　　　　　　　　 1. SQL Execution Process1) Execution ProcessWhen an Oracle instance

First, the use of the environmentOperating system: CentOS Release 6.2 (Final)Database: Oracle 12gDatabase home directory:/ora12/product/product/12.1.0/db_1Ii. Description of the problemAfter logging in to sqlplus with the SYS user, prompt when

Completed Oracle 10g database and forgot to unlock the Scott account. This can be in the SQL Plus tool (start | All Programs || Application Development | SQL Plus), or you can unlock the Scott account from the console via the command line.In the

First, the basic concept of the databaseIi. Examples of databasesIII. Features of OracleIv. Oracle VersionV. Installation of Oracle ConsiderationsVI. Introduction to SQLVII. SELECT statementsFirst, the basic concept of the databaseDatabase (DATABASE,