what is the syntax of CREATE command?
Answers were Sorted based on User's Feedback
Answer / chandiran
CREATE TABLE <table name>
(<column name> datatype,.....)
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / venu gopal
create table <table name> [<column1> datatype,.....]
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / guest
create table <table name>(column definition1, column
definition2,...);
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / guest
create table tablename(col1 datatype,col2 datatype...);
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / anand
create table tablename(
columnn1 (data type)
columnn2 (data type)
columnn3 (data type)
columnn4 (data type)
);
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / devraj
Before posting a answer for this quistion i would like to
know which object you want to create in oracle? Bacuse
command will be diffrent for diffrent objects.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / guest
create table tablename(data type1,....data typen);
| Is This Answer Correct ? | 1 Yes | 6 No |
What are inner join and outer join?
acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account
What are the various constraints used in oracle?
How to Truncate Table in Oracle
what is the exact definition for pointer?
How to use regular expression in pattern match conditions in oracle?
What happens if recursive calls get out of control?
What is E-R diagram ?
2 Answers CGI, Keane India Ltd,
what is data independence exactly? give an example
How to create a new table in your schema?
What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
What do you mean by a database transaction & what all tcl statements are available in oracle?