oracle study guide

Oracle Database pl SQL study notes, oraclepl 1. define basic variables:2. referenced variable: set serveroutput on declarepename emp. ename % type; psal emp. sal % type; beginselect ename, sal into pename, psal from emp where empno = '000000'; dbms_output.put_line (pename | 'salary:' | psal); end; /3. Record-type variables: set serveroutput on declareemp_rec emp % rowtype; beginselect * into emp_rec from em

, and the time of each query is recorded.The algorithm uniformly uses the algorithm that best fits the global Spatial index: Part_query3.4 Experimental resultsThe results of the experiment are as follows:Average of 3 samples per scale:A line chart that plots the response time of different partition granularity at different scales.5 Experimental conclusions Although the Global Spatial index is consistent, different data organization methods affect query efficiency. It can be seen that to

Common Sql*plus commands and environment variables----------------------------------query table Structure Command: describe (abbreviated DESC)Set Display output width: Set line [size] {80|n}List the statements for the SQL buffers: list (abbreviation L) after locating the error statement and modifying it, and then executing the correct statement/or run.Delete command: DelChange command: C/original/new bodyGenerate script: The Save command will deposit the contents of the SQL buffer into the speci

Tags: vlm x265 lmos jsf2 RTK SRM LVM csdn file Enter OEL Click Skip Click Next Select default Select default Select OK In the Red box, select Create custom layout Click New Select Swap,size in file System Type now 4096 At mount point Select/ In additional size options select Fill to maximum allowable size To view the partition, click Next Click Next Click Edit In the Virtual network editor in

| | '. ' | | a.index_name| | ' rebuild nologging online; 'From Dba_indexes Awhere A.table_name= ' WWFF 'and a.statusand a.partitionedSteps to read 3Hint forced to walk the index (only used to view the hint state, whether the query changes, the application can not be changed)Select/*+index (WWFF idx$$_wwff_jgsj) */* from WWFFwhere Jgsj>=to_date (' 2014-10-26 00:00:00 ', ' yyyy-mm-dd HH24:Mi:SS ')and Sjzt=1 and Fjbj=3 and Fjr=1 and rownum Takes 0.03 secondsAfter forcing the index, it takes only

Tags: OracleOracle RAC Study--delete vote DISKEnvironment:Operating System: AIX 5300-09Cluster Software: CRS 10.2.0.1Database: Oracle 10.2.0.1There are two ways in which RAC can be used to build an AIX platform based on shared storage:1. Establish shared storage based on concurrent volume group (VG concurrent)2. Build shared storage based on ASM Raw 650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02

Oracle Study Notes --- (5) V. 1. define abstract data types/*Create or replace type animal_ty as object(Breed varchar2 (25), -- animal typeName varchar2 (25), -- nameBirthdate date, -- Date of birthMember function age (birthdate in date) return number -- calculate the age based on the date of birth); -- Abstract data type with Method*/Create or replace type animal_ty as object(Bread varchar2 (25),

Oracle Study Notes (6) -- FunctionsFunction functions facilitate statistical processing of data query result functions classification Oracle built-in system functions numeric functions rounded to ROUND (n [, m]) 1, n: 2. m: indicates the number of digits after the decimal point or the first digit. 3. m: 0 4 is omitted. m> 0: example: select round (23.4), round (2

SET Events ' 10104 Trace name Context forever, Level 2 ';Select COUNT (1) from t1,t2 where t1.object_type = T2.object_type;Alter session SET Events ' 10104 Trace name context off ';Number of buckets with 0 rows:131027Number of buckets with 1 rows:3Number of buckets with 2 rows:2Number of buckets with 3 rows:2Number of buckets with 4 rows:2Number of buckets with 5 rows:1Number of buckets with 6 rows:0Number of buckets with 7 rows:1Number of buckets with 8 rows:0Number of buckets with 9 rows:4Num

In theOracle spatial Partitioning application Research: partition and sub-table query performance comparison has been explained: by the county partition + Global Spatial index efficiency is better than by county partition + local spatial index, so in the experiment report, the combination of county partition + local spatial index is no longer considered, The experimental subjects of this experiment are as follows 3: by county partition + Global Spatial Index By city partition + loca

Oracle provides file action packages for utl_file in Utl_file packages. Fopen is responsible for opening a file. Utl_file. FOPEN (varchar2, filename in varchar2, open_mode in varchar2) return file_type; Location is the path parameter, filename is the filename, Open_mode is the open mode, ' R ' is the read text, ' W ' is the text, ' A ' is the appended text, the parameter is not case-sensitive, if the specified ' a ' but the file does not exist, it wil

Oracle study note (4) Foreign key-create table major_ning (mid number (2) primary key, mname varchar2 (30) referenced in the master table (parent table )); -- from the table (sub-table), refer to the create table student_ning (id number (5) primary key, name varchar2 (20), mid number (2 ), constraint stuning_mid_fk foreign key (mid) references major_ning (mid); insert into major_ning values (1, 'computer ')

Oracle self-study (3) [SQL] pl/SQL language and programming: declare --- declare variable begin --- execute statement except10n end; for example: declare v_department char (3); v_course number; begin insert into classes (department, course) values (v_department, v_course); end; Pl/SQL statement control structure 1. Select structure if condition expression then Statement 1 else if condition expression then S

There are three types of data changes in the database: insert, update, and delete ). These operations are common to developers. There are three types of data changes in the database: insert, update, and delete ). These operations are common to developers. There are three main types of data changes in the database: insert data ( InsertOperations and precautions UpdateOperations and precautions DeleteOperations and precautions Through the study in

There are three main types of data changes in the database: insert data (Insert), Modify data (Update), Delete data (Delete). These operations are commonly used by developers. This chapter briefly introduces these operations. The main contents of this chapter include: InsertOperations and precautions UpdateOperations and precautions DeleteOperations and precautions Through the study in this chapter, readers can learnInsert/update/deleteThe basic opera

data is added time is April 10 23:59 59 seconds, so and July 1 The result of the operation is: 2.67741972If the data is added time is April 11 0:0 0 seconds, so and July 1 The result of the operation is: 2.67741935The results of the April 10 and July 10 calculations are: 2.70967741In order to ensure the controllability of time, think of the use of the day, to remove the time of cent secondsThe specific code is as follows: (using To_date (' 20150701 ', ' YYYYMMDD ') to simulate time parameters)S

Click Continue Click Forward Click Finish After reboot, enter the system, username root User password installing VMware Tools Open Terminal Enter Cp/media/vmware\ tools/vmwaretools-9.6.1-1378637.tar.gz. Unzip, Tar-xvzf vmwaretools-9.6.1-1378637.tar.gz RM vmwaretools-9.6.1-1378637.tar.gz Enter Y CD vmware-tools-distrib/ Installation./vmware-install.pl Enter 12 times, to select the resolution, input 3, retur

Follow the configuration of your machine Processor configuration Follow the configuration of your machine Memory for this virtual machine Network type Select I/O Controller type Select disk Type Select disk Allocate the disk capacity of the virtual machine, depending on the size of your disk Specify disk files Click on Custom Hardware Ready to create virtual machine Hardware Remove Hardware Last View [

,Count (H.houseslevel) as the latest cumulative required sell, COUNT (H2.houseslevel) as the latest cumulative disk from houses h,houses H2,Areas a WHERE H.areaid=a.areasid and H2.areaid=a.areasid and H.finalassessmentid=1 and h.houseslevel=2 and H2.houseslevel =1 and A.areasid!=a.parentareasid and a.companysid=2;SELECT A.areaname AS Level two place name from houses H,areas a WHERE h.areaid=a.areasid and A.areasid!=a.parentareasidSELECT A.areaname AS Level two place name from areas a where a.are