-- select * from (select 'asd' as org_name from DWD__IN_REGISTER   )  where  rownum <=10;
-- INSERT INTO  TEST_1014 (NAME, AGE) VALUES ('pangjq',22);
-- select
-- NULL as ORI_OPER_PART_NAME,--机构内手术(操作部位名称
-- NULL as INCISION_HEALING_NAME,--标准切口愈合等级名称
-- NULL as VISITING_NO--就诊号
--  from   MD_USERS
--         create  tablespace test2  --创建一个表空间
--         datafile 'test2'              --物理文件名
--         size 50m                                  --大小
--         autoextend on                          --自动增长
--         next 50m maxsize 20480m     --每次扩展50m，最大为20480m
--         extent management local;
--  select * from v$tablespace;
-- drop tablespace TEST1018;
-- select * from v$tablespace;
-- select * from (select 42 as ANA_WAY_CODE  from TEST1018 )  where  rownum <=10

-- select *
-- from user_tab_columns
-- where Table_Name='用户表'
-- order by column_name
-- select COLUMN_NAME from user_tab_columns t3 where t3.TABLE_NAME=upper('DWD__IN_REGISTER');
-- select * from all_tab_cols t where t.column_name='ABC';

-- select * from all_tab_cols t where t.column_name='ABC';
--
-- select A.COLUMN_NAME,A.DATA_TYPE  from user_tab_columns A
-- where TABLE_NAME='DWD__IN_REGISTER'
-- select USERNAME from sys.dba_users

-- create table test1020 (id INT) TABLESPACE DWD_213_20211019;
-- select * from  TABS

-- select TABLE_NAME,TABLESPACE_NAME from dba_tables where TABLESPACE_NAME='DWD_213_20211019';

INSERT INTO test1020 id values (1);

　　记录