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 |
How to run queries on external tables?
when loggined as SYSTEM,how to display all the users of database using sql query?
What would you do if a database crashes in production?
How do I escape a reserved word in oracle?
what is a cartition product?
Can sub procedure/function be called recursively?
Name the various constraints used in oracle?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
which sql command we can use to get a print out from oracle?
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
why pl sql doesn't support retrieving multiple records
How can we Update a table with out using UPDATE command?