-
编辑 删除
sfdsfdsfd
CREATE UNDO TABLESPACE MY_UNDODATAFILE '/test/db/undo_01.dbf' SIZE 2048M, '/test/db/undo_01.dbf' SIZE 2048M;ALTER SYSTEM SET UNDO_TABLESPACE=MY_UNDO SCOPE=SPFILE;SHUTDOWN IMMEDIATESTARTUPALTER TABLESPACE UNDOTBS1 OFFLINE;---------------------------------------------------------CREATE TEMPORARY TABLESPACE MY_TEMPTEMPFILE '/oradata/temp/tmp_01.dbf' SIZE 1024MREUSE;---------------------------------------------------------CREATE TABLESPACE MY_DATADATAFILE '/oradata/dat_01.dbf' SIZE 1024M,
-
编辑 删除
行转列
SQL> select * from test;ID MC---------- -------------1 111111 222222 111112 222223 111113 222223 33333已选择7行。SQL> select id,ltrim(max(sys_connect_by_path(mc,',')),',') row2colfrom (select id,mc,id+(row_number() over(order by id)) node_id,row_number() over(partition by id order by id) rnfrom test)start with rn = 1connect by node_id-1 = prior node_idgroup by idorder by id;ID ROW2COL---------- -------------------------------------------------------------1 11111,222222 11111,222223 11111,2
