SQL*Plus (MOSC)

MOSC Banner

Blank lines in output

edited May 28, 2009 7:32PM in SQL*Plus (MOSC) 4 commentsAnswered
Hello,
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')

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center