Interested to Buy Any Domain ? << Click Here >> for more details...
what is the syntax of CREATE command?
- 8 Answers
- 10650 Views
- I also Faced
- E-Mail Answers
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 can you use check constraints for self referential integrity?
Can we insert data in view oracle?
Whatz the main diff between Subquery and a Join
14 Answers Oracle, Zeta Interactive,
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
What is an oracle tablespace?
Explain an exception and its types?
What suggestions do you have to reduce the network traffic?
How many memory layers are in the shared pool?
What is an oracle and why it is used?
Can sub procedure/function be called recursively?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
Oracle General 
