Blank lines in output
Hello,
I have a script do describe primary and unique keys of tables.
It looks like this:
I have a script do describe primary and unique keys of tables.
It looks like this:
REM Display Primary key of a table
set verify off
set feedback off
set recsep off
set trimspool on
set pagesize 8000
set recsepchar "-"
set linesize 800
rem set wrap off
break on "Table" skip page nodup on "Key" nodup
column "Key" format a30 fold_b
column "Id" format 999
column "Column" format a30
select uc.table_name "Table", ' ' || uc.constraint_name "Key",
position "Id", column_name "Column"
from user_constraints uc, user_cons_columns ucc
where uc.table_name like upper('&&1')
0