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 get count of tables in particular database in Oracle?
What is oracle open database communication (odbc)?
What are the uses of synonyms?
What is the difference between RBBMS & DBMS?
how many outer joins are used in a single sql query? is there any limitations for using of outer joins?
2 Answers BOB Technologies, Cap Gemini, IBM,
How many types of tables are there in oracle?
What is a database table in oracle?
How to empty your oracle recycle bin?
List the parts of a database trigger.
difference between truncate and delete ,drop?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
how to find count rows in table without count function?