Oracle

Http://www.oracle.com/technetwork/database/windows/downloads/index-093848.html http://blog.csdn.net/robin_he/article/details/7345842 Oracle 11g R2 11.2.0.3 Patch set for Winnt 32bit Do not explain the need to hurry down AH 115 closed

--Query and print the employee's name and salary --set serveroutput on /* 1, the cursor's properties %found: False if the record is taken, %notfound: * * DECLARE --defines a cursor cursor cemp is select ename,sal from emp; --Define the

--Create a test table name CREATE TABLE job_table (run_date date); --Create a stored procedure Create or replace procedure Job_proc as Begin Insert into job_table (run_date) values (sysdate); End --Create a job and specify one minute

There is a table named TB with the field segment named name and data type nchar (20). 1, assuming that the field data is empty, no matter what type of field to change, you can directly execute: ALTER TABLE TB Modify (name Nvarchar2 (20)); 2,

First, row to column In some application scenarios, such as student achievement. The students ' scores in all subjects are saved to a table, and when we need to display the results of each subject in the form of a list, we need to use the row-column.

1, take the record from the table randomly SELECT * FROM (SELECT * to Staff ORDER by Dbms_random.random) indicates that 3 records are randomly taken from the staff table Where RowNum 2. Produce random number SELECT Dbms_random. RANDOM from

global_name of Oracle database Global_name of the Oracle database, as mentioned in the database link and global_names parameters, when setting the Global_names initialization parameter to TRUE, the local database link name must be GLOBAL_ with the

Small knowledge Point: Dual is a pseudo table, is a single field, a row of records of the table. do not need to get the data from the table, but simply in order to get some of the information we want, and to complete through select, it is

--TableCREATE TABLE test (names VARCHAR2 (12),Dates date,Num INT,Dou double);--ViewCreate or replace view vi_test asSELECT * from Test; --SynonymsCreate or replace synonym AAFor DBUSRCARD001.AA; --Stored proceduresCreate or replace produce DD (v_id

At the time of writing hibernate code, a "table or view does not exist" error occurs when you want to save to the Oracle database, but when you enter the database, the table is present and can be edited and analyzed to find that it was created with

Create the following in the Sqlplus:1, Package Sql> Create or Replace package types2 AS3 type CursorType is REF CURSOR;4 End;5/ The package has been created. 2. functionsql> Create or Replace function sp_listemp return Types.cursortype2 AS3 L_cursor

http://skzr-org.javaeye.com/blog/811491 Goal: Timed export: Use Scheduled tasks to automatically compress: using the command line RAR automatic monthly storage: using cmd Code:   CMD code @echo   must go to the specified path, otherwise it will

SELECT statements in Oracle can use the start with ... Connect by prior clause implements recursive query, connect by is used in structured query, its basic syntax is: SELECT * FROM tablename start with Cond1 Connect by Cond2 where Cond3; In short,

The "Exp-00003:no storage definition found for segment ..." error occurs when you export a table with a LOB object using the previous version of EXP from version 9205 (or more).This is a bug for Oracle, and for this bug, the following processing can

As the saying goes, the user is God, they sometimes ask a question very simple, just need a word, a minute will be done, but to our DBA, it may be at least half an hour or even half a month to meet his words, there is a better and faster way, I tell

I. Creating an instance of a package specification:Create or Replace package pack_op is Procedurepro_print_ename (ID number,value2 out number); Procedurepro_print_sal (ID number); Functionfun_re_date (ID number) return date; End Pack_op; To create a

Oracle gets the current date and date format Get system Date: Sysdate ()Format Date: To_char (Sysdate (), ' Yy/mm/dd HH24:MI:SS)or To_date (Sysdate (), ' Yy/mm/dd HH24:MI:SS)Format Number: To_number                Note:      to_char  Converts a

2007.1.23 12:31 Author: showxz | Rating: 0 | Reading: 465 Dataload is isn't an Oracle tool. So, that's sells, which means if you can come up with a better tool, your may sell it and the would be waiting; dOracle provides some tools to help data

1. View Oracle Encoding command Select Userenv (' language ') Nls_lang from dual; 2. The Change Order is as follows sql> Conn/as sysdba sql> shutdown immediate;Sql> Startup Mountsql> ALTER SYSTEM ENABLE restricted session;sql> ALTER SYSTEM SET

1. Create user table Space Detail Datasheet space table Tcm_adminRun under Plsql:Create Tablespace Tcm_adminLoggingDataFile ' d:/oracle/product/10.2.0/oradata/tcm_admin.dbf 'Size 1024mAutoextend onNext 512m MaxSize UnlimitedExtent management