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
steffeli
Messages: 112
Registered: July 2006
Senior Member
Hello

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!
Stefan
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: 64122
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

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


Current Time: Wed Dec 07 05:18:17 CST 2016

Total time taken to generate the page: 0.15472 seconds