Home » RDBMS Server » Server Administration » urgent
urgent [message #372879] Thu, 15 March 2001 07:46 Go to next message
Anna
Messages: 30
Registered: March 2001
Member
Can someone please tell me how to generate a file of al the table_name in a specicific schema with all their columns changed to varchar2(300) datatype.

Report message to a moderator

Re: urgent [message #372886 is a reply to message #372879] Thu, 15 March 2001 11:34 Go to previous messageGo to next message
Balamurugan.R
Messages: 91
Registered: March 2001
Member
Hi jonas,

Please send that script, which will be useful
to me, my mail id is balus77@rediffmail.com.

With Regards,
Balu

Report message to a moderator

Re: urgent [message #372889 is a reply to message #372879] Thu, 15 March 2001 12:14 Go to previous message
Andrew again...
Messages: 270
Registered: July 2000
Senior Member
generate the file in sqlplus, change the where clause as needed.

spool mod_col_300.sql
select 'alter table '||table_name||' modify ('||column_name||' varchar2(300));' from user_tab_columns
where data_type = 'VARCHAR2' and data_length < 300
spool off

Report message to a moderator

Previous Topic: Need Help on a complex SQL to eliminate data
Next Topic: Partition problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 01:00:24 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.