Home » SQL & PL/SQL » SQL & PL/SQL » Create table from two different tables [Merged]
Create table from two different tables [Merged] [message #235365] Sat, 05 May 2007 06:44 Go to next message
binnnu
Messages: 5
Registered: May 2007
Junior Member
how to add two tables i mean how can i make new table which have both tables structure

[Updated on: Sat, 05 May 2007 06:56]

Report message to a moderator

create table [message #235367 is a reply to message #235365] Sat, 05 May 2007 06:51 Go to previous messageGo to next message
binnnu
Messages: 5
Registered: May 2007
Junior Member
how to create table which have column of another table and one more
additional column which is not in inherit table
Re: table [message #235369 is a reply to message #235365] Sat, 05 May 2007 06:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Precise your question.

Regards
Michel
Re: create table [message #235370 is a reply to message #235367] Sat, 05 May 2007 06:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
create table new_table as
select old_table.*, cast (<value> as <datatype>) as new_column
from old_table
/

Regards
Michel
Re: create table [message #235372 is a reply to message #235370] Sat, 05 May 2007 07:05 Go to previous message
binnnu
Messages: 5
Registered: May 2007
Junior Member
thank you very much
Previous Topic: select query..
Next Topic: retrieve a column content
Goto Forum:
  


Current Time: Sat Dec 03 18:22:08 CST 2016

Total time taken to generate the page: 0.11439 seconds