what is the syntax of CREATE command?

Answer Posted / guest

create table tablename(col1 datatype,col2 datatype...);

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I manually create a database in oracle?

548


What is the difference between post-database commit and post-form commit?

517


How to use subqueries with the in operator using oracle?

614


Difference between hot backup vs. Cold backup?

606


How to define an explicit cursor in oracle?

603






What is a table index?

565


Please explain oracle left join with an example?

587


What are the different pseudo commands? Explain in general?

542


What are the different types of synonyms?

601


What are the restrictions in a oracle read only transaction?

574


Explain the use of consistent option in exp command.

554


Difference between pre-select and pre-query

579


What happens if you set the sga too low in oracle?

559


i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1472


In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

1927