Oracle

1, to the database, the table of each row of data record additions and deletions to changeAdd: INSERT into Table name values ()Delete: Delete table name where condition (id=? ）Change: Update table name set column name =? Where Condition (id=? ）Check:

There are six steps to modifying the Oracle instance name:1. Sqlplus Username/password as SYSDBA, then create Pfile file from SPFile file: Creation Pfile from SPFile2, modify the pfile db_name parameter name is demo, and then save it.3. Create

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

A FOREIGN key constraint (that is, referential integrity constraints)Example: There are two tables following the referential integrity between themCreate Tablestudent (--Student tableS_ID Number (5) primary key,S_NAMEVARCHAR2 (20),T_IDVARCHAR2

Usage of prior in Oracle treePrior plays a crucial role in Oracle spanning tree, which determines the direction of the book's Traversal. Here are the examples:1, prior in the child node direction (so-called child node direction refers to the field

--stored procedures, querying a table, inserting data into table BCreate or Replace procedurePrc_sg_sjtj_config (P_flag outvarchar2) isBEGIN forC_rowinch(SELECTT.unit_name, T.data_name, T.table_name, T.update_od R, DECODE (T.data_methods,'file',

General insert syntax is not said, there are some special usage1. Insert Allinto table1 (col1,col2) VALUES (V1,V2)into table2 (col1,col2) VALUES (V1,V2)......Select ...;The following select directly affects the previous into, and each record is

1. Change the machine name~]# hostnamectl--static Set-hostname Oracle2.~]# su-oracleLast login:tue April 10:11:34 CST from 192.168.30.250 on pts/0[Email protected] ~]$ lsnrctl statusLsnrctl for linux:version 11.2.0.1.0-production on 12-apr-2016 10:19

1: Unlocking the userAlter user username account unlock;2: Get system time, random numberSelect Sysdate, Sys_guid () from dual;3: Alias, make it more readable, if you want to preserve the original appearance of the field, you canSurround with double

At the same time, modify Tnsnames.ora, Listener.ora the two files in the host behind hosts are modified to 127.0.0.1 and then restart Oracleservicexe, Oraclexetnslistener servicesListener.ora file revised toSid_list_listener = (Sid_list = (Sid_desc =

Oracle Database elementary learning, oracle Database elementary SQL query statement on the first day CMD--SQLPLUS ---- account soctt password tiger, enter the SQL database after the input is complete, it shows that the connection is successful.  

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

0008 notes 04-subquery, join and combined query, and 04- 1. subquery: Nested query. The results of one query are used as the conditions for another query. For example, to list the IDs, names, and contacts of all customers who have ordered the item

Detailed description of Oracle custom exception examples, detailed description of oracle custom 1. The error box is displayed: Sample Code: Declare v_count number; begin select count (*) into v_count from dept; if v_count Execution result: 2.

Oracle timestamp added valueDuring my work, I encountered this problem. The session table needs to use the timestamp field. When the timestamp field is updated, the question is displayed. For example, the validity period of the session needs to be

40. Installation Steps of Oracledatabase11g in Windows XP Example of how to install Oracle11g R2 on Windows 7 32-bit operating system. Let's just talk about it. 1. Extract the two oracle 11gR2 packages to a separate folder. 2. Find setup.exe in the

Install and use Oracle in windows I. Download the oracle database from the official website Here I downloaded oracle 11g r2, and selected the corresponding download file based on my operating system. Here I am windows 64-bit, so select the second

Oracle Database remote connection configuration tutorial I have worked on Oracle databases some time ago, but I found that the database listening program and service name are difficult to handle, and there is no ready-made tutorial on the Internet.