Oracle

The composition of a pack1) Baotou (package): Baotou part of the declaration of data types, constants, variables, cursors, subroutines and exception error handling,These elements are the public elements of the package.2) Package Body: The package

#搜索用户SelectDefault_tablespace,username fromDba_userswhereDefault_tablespace like 'newyz%'; #搜索连接的用户sessionidSelectusername,sid,serial# fromV$sessionwhereUsername= 'Newyz';

Cast (the value to be converted as the type of the conversion);Question: "As Fsubbillno if the Oracle default field type is char and the field length is the length of the input space, it causes the string to be very long or to be mismatched when

I. Allocating space to empty tables: This step must be done, otherwise an empty table cannot be exported.First connect the library you want to export, and execute the following SQL on the library:Select ' ALTER TABLE ' | | table_name| | '

1.union: perform a set operation on two result sets, excluding duplicate rows, and sorting the default rules;SELECT **12.UNION ALL: Set operations on two result sets, including repeating rows, without sorting;SELECT ** *1;3.intersect: The

--If you create a global dblink, you must use the SYSTM or SYS user to add public before database. Create / * Public * / Database Link Dblink1  Connect to Dbusername identified by Dbpassword  using ' (DESCRIPTION = (Address_list = (ADDRESS =

PL/SQL is also a language, and background development is often used.At present to do to a function, about the "report task scheduling", said to understand is to do a few reports, daily statistics of new data, used in the PC page display, I have been

Create or replace directory Dumpdir as ' E:\oracle\dumpdir ';Create temporary tablespace ydxt_tempTempfile ' E:\oracle\product\10.2.0\oradata\ydxt\ydxt_temp.dbf 'Size 50mAutoextend onNext 50m maxsize 20480mExtent management Local;Create Tablespace

--1 The simplest stored procedure create or replace procedure Hello_proc as V_name varchar2 (20); V_age number; Begin v_name:= ' Bai '; v_age:=18; Dbms_output.put_line (' Hello ' | | v_name| | ', you this year ' | | V_age); end;--call in Plsql

Create a test tableCREATE TABLE TEST (ID number (+) is not NULL,NAME VARCHAR2 (+) is not NULL,PRIMARY KEY (ID));//Insert a piece of dataINSERT into TEST VALUES (5, ' php_book ');//Create a stored procedureCREATE OR REPLACE PROCEDURE proc_test (P_ID

Encounter a requirement: in the already built database, add the same 3 fields for each data table.Analysis: Data tables in the database are many, one-by-one manual modification time-consuming inefficient, can you use the program to traverse each

Table space is not sufficient to add a tablespace database fileAlter tablespace USERS add datafile '/oracle/app/oradata/shpog/user02.dbf ' size 16G autoextend on;Alter tablespace SYSTEM add datafile '/oracle/app/oradata/shpog/undotbs01.dbf ' size 5G;

Connection Pool configuration file apache-tomcat-7.0.40-windows-x64\apache-tomcat-7.0.40\confcontext.xml in Tomcat in Name= "Jdbc/easybuy"Auth= "Container"Type= "Javax.sql.DataSource"factory=

1 Start-run-services.msc 2Locate the service Oracleoradb10g_home1tnslistener and ORACLESERVICEORCL Note the ORCL service name. these two areOracleThe two services that are required to start are automatically started by default the two services are

1. A B C is in the table three columns, with SQL Statement implementation: When a column is greater than B Select a When column column otherwise select B column, when B column is greater than C Select B when column column otherwise select C column.

--Query Tablespace usage SELECT UPPER (f.tablespace_name) "tablespace name", D.TOT_GROOTTE_MB "tablespace size (M)", d.tot_grootte_mb-f.total_bytes "empty Room (M) ", To_char (ROUND ((d.tot_grootte_mb-f.total_bytes)/d.tot_grootte_mb * 100,2), ' 990.9

Oracle Startup DatabaseStartup [nomount| Mount| open| Force] [Restrict] [pfile=filename]Launch the instance, load the database, start the databaseOracle shuts down the databaseShutdown [Immediate|normal|trasanctional|abort]Close the database, unload

CREATE TABLE Space User authorizationCreate tablespace liuzhen_tablespace datafile ' D:\liuzhen_oracle_data\liuzhen_data.dbf ' size 50m autoextend on next 5 0m maxsize 20480m extent management local;Create user Liuzhen identified by 123456 default

Oracle's three highly available cluster scenariosThere are three main types:1. RACRAC, Real application ClustersMultiple Oracle servers form a shared cache, and these Oracle servers share a network-based storage. This system can tolerate single-or

Single-line Comment:--Multiline Comment:/* */modifying table Structures in OracleAdd FieldALTER TABLE table_nameADD column_name data_type;Delete a fieldALTET TABLE table_nameDROP COLUMN column_name;modifying field typesALTER TABLE table_nameALTER