Select with column long
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Select with column long

  1. #1
    Join Date
    Dec 2000
    Posts
    15

    Post

    hi !!!
    I need to make one select in user_cosntraints but this column search_condition is the data type Long. How ill make this

    select 'alter table '||table_name||' add constraint '||
    ' check ('||seach_condition||');' from user_constraints
    where constraint_type = 'C'

    thanks !!
    Sandro Lobo
    Oracle DBA
    www.geocities.com/sslobopt

  2. #2
    Join Date
    Nov 2000
    Posts
    212
    select 'alter table '||table_name||' add constraint ' a1,
    constraint_name||' check (' a2,
    search_condition a3,
    ') '||decode(status,'DISABLED','DISABLE','') a4,
    '/' a5,
    table_name a_table

    and if sqlplus, then
    set long nnnn (eg. 100000)

    Otherwise use PL/SQL: in 815 you really can fecth long into varchar2.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width