Answer / ram

create table <table name> [<columns> datatype];

Answer / chandiran

CREATE TABLE <table name>
(<column name> datatype,.....)

Answer / venu gopal

create table <table name> [<column1> datatype,.....]

Answer / guest

create table <table name>(column definition1, column
definition2,...);

Answer / guest

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

Answer / anand

create table tablename(
columnn1 (data type)
columnn2 (data type)
columnn3 (data type)
columnn4 (data type)
);

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.

Answer / guest

create table tablename(data type1,....data typen);

create or replace procedure show_tab_rec ( P_tab VARCHAR2 ) IS cmd varchar2(50); begin cmd := 'select * from '|| P_tab; for int in ( execute immediate cmd ) loop dbms_output.put_line ( int.ename||' '||int.deptno); end loop; end; when i m compling this procedure i m getting this error PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following: . ( ) , * @ % & | = - + < / > at in is mod remainder not range rem => .. <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ PLZ solve this error give this question answer asap Thanks advance.......

1 Answers   HCL,

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

0 Answers  

How to use subqueries with the exists operator in oracle?

0 Answers  

What are steps required to ENTER DATA INTO DWH?

2 Answers  

In Oracle 10g, "g" Stands for what?

5 Answers   Mphasis,

What is a trigger and what are its types?

0 Answers  

What is a dead lock in oracle?

0 Answers  

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,

what is the syntax of UPDATE command?

8 Answers  

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

0 Answers  

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

0 Answers  

Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.

1 Answers