Oracle

Oracle useful PL/Sql

COLUMN colname FORMAT A50
-- *************************************************************
/*
SELECT COLUMN_NAME FROM user_tab_columns
WHERE TABLE_NAME = 'STR_REGION'
*/
BEGIN
declare
res PKG_DATA_SOURCE_MANAGER.cur_ref ;
ress varchar2(50);
nu number:=0;
tabname varchar2(10):='STR_REGION';
begin
PKG_DATA_SOURCE_MANAGER.SP_Get_ColumnList(tabname, res);
begin
loop
FETCH res into ress;
EXIT WHEN res%NOTFOUND;
DBMS_OUTPUT.PUT_LINE (nu || ': Column: ' || ress);
nu:=nu+1;
end loop;
end;
end;
END;
/
-- *************************************************************
begin
declare
cursor user_group_cursor is
SELECT COLUMN_NAME FROM user_tab_columns
WHERE TABLE_NAME = 'STR_REGION';
begin
for user_group_row in user_group_cursor
loop
DBMS_OUTPUT.PUT_LINE (': Column: ' || user_group_row.COLUMN_NAME );
end loop;
end;
end;
-- *************************************************************