-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|