Home » SQL & PL/SQL » SQL & PL/SQL » create table (oracle 9i)
create table [message #379178] Mon, 05 January 2009 04:57 Go to next message
modhiyakomal
Messages: 49
Registered: November 2008
Location: US
Member
Hi all,

there is a very basic question, for that i have searched but did not get proper answer.

can i create a table whose column names and data types are same as another table. but should not contain same values as another table?

thanks
Re: create table [message #379179 is a reply to message #379178] Mon, 05 January 2009 05:01 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
CREATE TABLE t2 AS SELECT * FROM t1 WHERE 1=2
Re: create table [message #379181 is a reply to message #379179] Mon, 05 January 2009 05:05 Go to previous messageGo to next message
modhiyakomal
Messages: 49
Registered: November 2008
Location: US
Member
thanks a lot JRowbottom.
Re: create table [message #379191 is a reply to message #379178] Mon, 05 January 2009 05:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
for that i have searched but did not get proper answer.


I don't trust you, this is a FAQ.

Regards
Michel
Re: create table [message #379203 is a reply to message #379191] Mon, 05 January 2009 06:13 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Michel Cadot wrote on Mon, 05 January 2009 12:33
Quote:
for that i have searched but did not get proper answer.


I don't trust you, this is a FAQ.

Regards
Michel


Oh, this is very well possible. Searching is something you have to learn as well. Not everyone is capable of coming up with the correct keywords.
I know people who can't find anything through Google, simply because they cannot think of the correct words to use.
Re: create table [message #379467 is a reply to message #379191] Tue, 06 January 2009 12:20 Go to previous messageGo to next message
modhiyakomal
Messages: 49
Registered: November 2008
Location: US
Member
Hi Michel,

u trust me or not i don't care. but simply if i already got an answer then why i submit my question on forum. and i don't like someone directly point out me. and yes i tried to find out the answer but According to Frank my keyword was not correct. so please stop to doubting the other people. i respect you because you are senior, but i'll not allow someone to directly point out me.

And i have read the rules for forum, According to that anyone can ask basic questions.

Re: create table [message #379471 is a reply to message #379467] Tue, 06 January 2009 12:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OK, next time say what you searched then we can tell you what you should have searched and then the next time you'll better know how to search.

Regards
Michel
Re: create table [message #379474 is a reply to message #379471] Tue, 06 January 2009 12:38 Go to previous messageGo to next message
modhiyakomal
Messages: 49
Registered: November 2008
Location: US
Member
Excuse me

i know very well how to search. i post in forum it doesn't mean i am student or your employee, so i'll listen whatever you'll tell me. i search 1000 things on google and if don't get 1 or 2 things, it doesn't mean i don't know how to search.
Re: create table [message #379478 is a reply to message #379474] Tue, 06 January 2009 13:10 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is not what I said.
You said "According to Frank my keyword was not correct", so you didn't know how to search for this question (the alternative is that you deliberatly wrongly searched) and so we could say how you could search to find the solution, knowing this you will then know how to better search the next time. Explain where I am wrong in my reasoning.
In addition, telling what you searched prove that you make the effort to search and then encourage people to help you.
Otherwise what is the purpose of your "for that i have searched but did not get proper answer"?

Regards
Michel
Previous Topic: Query help....
Next Topic: How can we do it
Goto Forum:
  


Current Time: Sat Dec 10 10:53:18 CST 2016

Total time taken to generate the page: 0.18818 seconds