Topic: SQL*Plus and PL/SQL >> Invalid column name???
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Invalid column name??? |
| vuong |
Posted: Jan 13, 2007 07:27:48 PM |
Total Post: 7
Joined: Jan, 2007
|
I am trying to create a ITEM table with the following code:
--Creation of Item Table
DROP TABLE ITEM CASCADE CONSTRAINTS ;
CREATE TABLE ITEM(
ITEMID NUMBER(6) NOT NULL,
ITEMDESC VARCHAR2(30) NOT NULL,
);
I get this error message:
SQL> @table.sql
DROP TABLE ITEM CASCADE CONSTRAINTS
*
ERROR at line 1:
ORA-00942: table or view does not exist
)
*
ERROR at line 4:
ORA-00904: invalid column name
Can som1 tell my why??
|
|
|
 maddy |
| Posted: Jan 14, 2007 02:48:44 AM |  |
|
Total Post: 18
Joined: Aug, 2006
|
hi,
Remove the comma(,) in the third line.....
SQL>CREATE TABLE ITEM(
2 ITEMID NUMBER(6) NOT NULL,
3 ITEMDESC VARCHAR2(30) NOT NULL);
Table created.
SQL> Drop table item cascade constraints;
Table dropped.
|
|
|
|
|
| Jayanta |
| Posted: Jan 14, 2007 04:54:08 PM | |
|
Total Post: 479
Joined: Feb, 2006
|
if there is no item table thn how oracle drop the item table??
that is why u got the error "ERROR at line 1:
ORA-00942: table or view does not exist"
create the item table first then try to drop it.
and the second problem is already explained by Maddy.
hope this will work
with regards
jayanta
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 327 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
