| naidu |
Posted: Dec 26, 2006 07:09:07 AM |
Total Post: 85
Joined: Nov, 2006
|
Which is a valid CREATE TABLE statement?
A. CREATE TABLE EMP9$# AS (empid number (2));
B. CREATE TABLE EMP*123 AS (empid number (2));
C. CREATE TABLE PACKAGE AS (packid number (2));
D. CREATE TABLE 1EMP_TEST AS (empid number (2));
Answer:
Plz help me on this question as soon as possible plZ |
|
|
 Jayanta |
| Posted: Dec 26, 2006 01:43:19 PM |  |
|
Total Post: 479
Joined: Feb, 2006
|
|
|
|
|
| sathish |
| Posted: Dec 26, 2006 10:14:23 PM | |
|
Total Post: 47
Joined: Mar, 2006
|
Correct ans:
-------------
A & c
Doubt:
how it is possible to create a table name package(tis not reserved word).
xpln pl......
|
|
|
|
|
| P |
| Posted: Dec 27, 2006 02:19:26 AM | |
|
Total Post: 6
Joined: Sep, 2005
|
All are invalid create statements...
if you remove the "AS" caluse in the create table statements:
A,C r correct.
you can create the table, with the table name "PACKAGE",
Hope this is fine
Regards
Surya
|
|
|
|
|
| sathish |
| Posted: Dec 27, 2006 03:07:18 AM | |
|
Total Post: 47
Joined: Mar, 2006
|
how its works????
PACKAGE is not a reserved word in oracle.why?
xpln pl......
|
|
|
|
|
| Jayanta |
| Posted: Dec 27, 2006 04:09:45 AM | |
|
Total Post: 479
Joined: Feb, 2006
|
hello satish
u better try to execute this statement
create table package(
name varchar2(10));
or
create table packageas(
name varchar2(10));
it will create a table package/packageas in ur own schema.
the rules for naming a table in oracle are
name can be max of 30 character long
name must notbe any oracle server reserved words
can contain only _,$ and # as special charater. though their use is not encouraged by oracle.
and should also remember the same rules also applies for naming table aliases and user name.
hope this will help.
with regards
jayanta.
|
|
|
|
|
| sathish |
| Posted: Dec 27, 2006 04:59:18 AM | |
|
Total Post: 47
Joined: Mar, 2006
|
thank u
But till now i not satisfied with ur exp????
why is not possible to create a table name like trigger,index...
but its possible to create table name like PACKAGE,Procedure,function
if we use these words as table name wat is demerits,where it's affects the performance.....of oracle database
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
