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: 65137
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: Thu Aug 17 04:39:45 CDT 2017

Total time taken to generate the page: 0.05553 seconds