CREATE OR REPLACE TYPE T_CHA AS TABLE OF CHAR; / 建立表 T2,表中的第二列的列类型为 T_CHA 嵌套表类型,并向表中插入数据。 CREATE TABLE T2 (C1 INT, C2 T_CHA); INSERT INTO T2 VALUES(1,T_CHA('A','B')); INSERT INTO T2 VALUES(2,T_CHA('C','D','E')); 查询表中数据。 SELEC...
1、创建一个表用于存储数据 CREATE TABLE T1(id INT); 2、创建一个存储过程, 计算获得的结果插入到T1表中 CREATE OR REPLACE PROCEDURE p1(x IN INT) AS y INT:= 10; BEGIN x := x + y; INSERT INTO T1 VALUES(x); END; / 3、调用存储过程 SQL> CALL p1(10); SQL> SELECT * FROM T1; 行...
CREATE OR REPLACE PROCEDURE SYSDBA.GET_AUTO_STAT_INFO_FUNC(task_id INT,total_stat INT,table_id INT, sch_name varchar(24), table_name varchar(24),curr_gath_tab_id INT, curr_gath_sch_name varchar(24), curr_gath_tab_name varchar(24),success_stat INT,fail_stat INT,task_start_time DATE...
CREATE OR REPLACE TYPE TYPE_ROW_SPLITSTR AS OBJECT ( _num INT, myfield NVARCHAR(500) ); --2.建表的行类型 CREATE OR REPLACE TYPE TYPE_TABLE_SPLITSTR AUTHID DEFINER is TABLE OF TYPE_ROW_SPLITSTR; 1. 2. 3. 4. 5. 6. 7. b.建表函数 --3.返回表的函数 CREATE OR REPLACE FUNCTION ...
CREATE or replace PROCEDURE proc_check_table(table1 varchar(100) , table2 varchar(100)) AS TYPE Rd IS RECORD(column_name VARCHAR(128), data_type VARCHAR(128)); v_row1 Rd; v_row2 Rd; cur cursor; BEGIN open cur for select column_name,data_type||'('||data_length||')' data_type...
CREATE TABLE T1(C1 INT ,C2 CHAR(1),C3 VARCHAR(10) ,C4 VARCHAR(10) ); CREATE TABLE T2(C1 INT ,C2 CHAR(1),C3 VARCHAR(10) ,C4 VARCHAR(10) ); INSERT INTO T1 SELECT LEVEL C1,CHR(65+MOD(LEVEL,57)) C2,'TEST',NULL FROM DUAL CONNECT BY LEVEL<=10000; ...
CREATE OR REPLACE TRIGGER update_person_age AFTER INSERT OR DELETE OR UPDATE ON person_table FOR EACH ROW BEGIN IF INSERTING THEN UPDATE person_table SET age = 20 WHERE id = :new.id; ELSIF UPDATING THEN UPDATE person_table SET age = :old.age + 1 WHERE id = :old.id; ELSIF DELETING...
CREATETABLEtestASSELECTuser_id,user_name,login_name,phonenumber,dept_idFROMsys_userWHERE1=2; 创建成功后查询可以看到表创建成功,带WHERE 1 = 2条件的话,实测是只创建指定字段表结构,不带WHERE条件的话会携带对应字段的数据 CREATETABLEtest1ASSELECTuser_id,user_name,login_name,phonenumber,dept_idFROMsys_...
create table hrtest.t_testpid( pid int, pname varchar(20), sex bit, logtime datetime) TABLESPACE dmtbs; 图形化方式 客户端操作区分大小写,建议统一使用大写。 12.2 数据导入 在disql里执行的话使用以下命令: start sql文件路径 在达梦客户端工具里执行的话,使用以下命令: ...
CREATEORREPLACEFUNCTIONinsertOnUpdate(p_table_name VARCHAR2,v_java NUMBER :=1)RETURNCLOBASv_is_pk PLS_INTEGER :=0;v_tf_c CLOB;v_sql_total CLOB;v_sql_join CLOB;v_sql_param CLOB;v_sql_update CLOB;v_sql_query CLOB;v_sql_insert CLOB;BEGINSELECTCOUNT(*)INTOv_is_pkFROMuser_cons_column...