KIN ORACLE

1.语法格式 MERGE   INTO   USING   ON ()  WHEN MATCHED THEN   DELETE   WHEN NOT MATCHED THEN   [LOG ERRORS ]; 2.测试数据 create table dept_bonuses (employee_id number, bonus_amt number); ins

1.测试数据 create table small_customers (customer_id number, orders number); create table medium_customers (customer_id number, orders number); create table large_customers (customer_id number,

SQL> select * from jay; SELECT_TIME ------------------------------------ 20130119 20130120 20130118 SQL> SELECT (CASE WHEN TO_CHAR( TO_DATE(select_time, 'yyyymmdd'), 'D' )= 1 THEN select_tim

WITH o AS( SELECT LEVEL rn FROM dual WHERE LEVEL >= 60000 CONNECT BY LEVEL <= 150000 ), result AS( SELECT rn FROM o WHERE MOD(rn, 3)= 2 AND MOD(rn, 5)= 3 AND MOD(rn, 7)= 4 AND MO

create table cp(u int,uname int,parentid int);

select sysdate now, sysdate+numtodsinterval(1,'second') add1second, sysdate+numtodsinterval(1,'minute') add1minute, sysdate+numtodsinterval(1,'hour') add1hour, sysdate+numtodsinterval(1,'day') add1day

CREATE OR REPLACE PROCEDURE PROC AS i NUMBER; j NUMBER; BEGIN i := 1; WHILE i <= 100 LOOP dbms_output.put_line(i); i := i + 1; END LOOP; FOR j in 1 .. 100 LOOP dbms_output

create or replace type type_col as object(e varchar2(36 char),n varchar2(100 char)); create or replace type type_tab as table of type_col; create or replace function f_return_rowtype(v_id varchar2)