Home » SQL & PL/SQL » SQL & PL/SQL » create a new table
create a new table [message #275947] Tue, 23 October 2007 08:33 Go to next message
Messages: 112
Registered: July 2006
Senior Member

I have a big table with around 300 parameters. How can I create a new table with the same content, but the parameter P100 multiplied by 0.3?

I could write all 300 parameters in the create statement, but is there an easier way to do that, without typing so much? (I also could run an update statement, but this is very slow).

Thanks for your help!
Re: create a new table [message #275961 is a reply to message #275947] Tue, 23 October 2007 08:58 Go to previous message
Michel Cadot
Messages: 63917
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ create table as select
2/ No unless you create as select * then update your single field

Previous Topic: Tuning SQL
Next Topic: From the stored procedure itself how to find out its name ?
Goto Forum:

Current Time: Mon Oct 24 18:41:29 CDT 2016

Total time taken to generate the page: 0.13451 seconds