Oracle

1. Download instantclient-basic-win32-11.2.0.1.0(Oracle official Website:http://www.oracle.com/technetwork/topics/winsoft-085727.html, 2:http://download.csdn.net/ detail/czw2010/5732241) 2. Unzip the instantclient-basic-win32-11.2.0.1.0 and place

Oracle Table Complex Query--sub-queryWhat is a subquery?A subquery is a SELECT statement embedded in another SQL statement, also called a nested query.Single-line subqueryA single-line subquery is a subquery statement that returns only one row of

1, char (size) holds a string, it can hold a maximum of 2000 characters, is a fixed length.To illustrate:CREATE table test1 (name char); The name field in the//test1 table holds a maximum of 32 characters and less than 32 characters Oracle will use

--MAX,MIN,SUM,AVG,COUNT,NVL (,)--Aggregate function--Max: Max value--Max can take the maximum value of the number, or the maximum value of the string (alphabetical order), according to the actual meaning of the scene, it is best to appear in a SQL

Recently in the business travel ticket platform, encountered such a problem:There is a tt_ticket table that is used to store ticket information. Inside there is a field called schedule, which represents the itinerary, the storage format is:

Since the project team is doing things with the DBA, it's not long before the DBA is gone, and almost the "chores" of the database are followed.Small white one, only Jingxiao micro operation. Often see the high water level and low water situation,

1. Open PL/SQL DeveloperIf PL/SQL developer is installed on the machine, open the PL/SQL Developer interfaceEnter the user name, password, and host name, which is exactly the same as configured in Web. config in the program, click OKLocate the

--Jobbegin sys.dbms_scheduler.create_job (job_name = "SSS. P_trms_car_task_job ', Job_type = ' Plsql_block ', job_action = ' BEGIN proc_tt_trms_car_task; END; ', start_date = to_date (' 21

Flashback recovering dataPreparatory work:1. Create a table spaceCreate tablespace zxq datafile ' d:\zxq.dbf ' size 2m;2. Create a userCreate user Zxq identified by zxq default Tablespace zxq;3. Create a test tableCREATE TABLE Zxq.zxq as SELECT *

The syntax for merge is as follows:MERGE [hint] into [schema.] table [T_alias] USING [schema.] {Table | view | subquery} [T_alias] On (condition) when matched and merge_update_clause when not matched then merge_insert_clause;What is merge and how is

Test user of Oracle database Scott's password why is Tiger?In June 1977, Larry Ellison and Bob Miner and Ed Oates co-founded a computer company called the Software Development Lab (software development laboratories,sdl) in Silicon Valley (Oracle

1. Query the profile information: SELECT * from SYS. Dba_profiles;SELECT * from SYS. Dba_profiles where profile= ' DEFAULT ';2.An example of creating a profile:1. CREATE profile "TEST"2. LIMIT3. Cpu_per_session 10004. Cpu_per_call 60005.

Assuming that you run the following command, you will basically find two root.sh scripts under the Oracle Software folder[Email protected] templates]$ find/u01/-name root.sh |xargs ls-ltr-RWXRWX---1 oracle oinstall 02:37/u01/app/db11g/product/11.2.0/

-Three Forms of loop (1). LOOP (2). While ... Looop (3). For ... LOOP1. Basic Loop statement set Serveroutput on;--exit ... when end loop declare v_value number (8): =-3; BEGIN >-loop tag loop dbms_output.put_line (' V_value = ' | | v_value);

First, disable constraintsALTER TABLE table_name DISABLE NOVALIDATE constraint constraint_nameSecond, bulk import dataBe sure to check the violation of the constraint before opening the constraint record1. Execute the script Utlexpt1.sql from Oracle

Oracle Self-Growth ID:Reference blog: Automatic incrementing of the Oracle Database creation table ID fieldMyBatis statementsReference blog: Reviews ibatis+oracle three ways to bulk insert. Refer to the third typeReference Blog: Two ways to BULK

　　Oracle queries　　　　One, simple queryORDER BYSelect T.sno, T.sname, t.ssex from STUDENT t ORDER byGroup BY Enhanced EditionSELECT P.toma, P.ptype, SUM (P.lastcou) from product P GROUP by Rollup (P.toma, P.ptype)　　　　Second, advanced query

The company has two databases in the environment, the version is different, one is 11g R2, the other is 10g R2First, export the database backup file with exp under 11g R2, and find that some of the tables are missing.Originally this part of the

Why is the data generated by Oracle garbled?the installation of the database and the client encoding code inconsistencies will produce garbled, To fix this problem, change the client code to1. select * FROM table;If this is the problem there are

I. Database DMP file ExportUnder the PL/SQL tool, select Export Tales, select all tables, and select the exported path.Second, database DMP file ImportCreate user table space;Create User: Grant DBA to AML;Execute Import Script: (premise: Windows