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 Schema Objects ?
How to use null as conditions in oracle?
how to retrieve 1st and last row of table without using group functions??
Describe Referential Integrity ?
What are the most common interview questions on ETL Testing for experience?
What happens if you set the sga too low in oracle?
difference between truncate and delete ,drop?
How to bring a tablespace offline?
What is the best way to do multi-row insert in oracle?
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
Explain self joins in oracle?
How to find out what privileges a user currently has in oracle?