| Problem with table created in lower case in user_tables [message #52967] |
Wed, 21 August 2002 22:31  |
Parag
Messages: 10
Registered: July 2002
|
Junior Member |
|
|
Hi,
I have created a table using following script:
create table "temp1" (Roll_no number (3), Name varchar2 (20));
Now the table gets created with a lower case entry in user_tables, and hence does not get recognized in any SQL statements as a table.
Now problem is, my friend is having Oracle 8.1.7 (On HP-UX 11) and I have 8.1.6 (On Windows NT workstation), the difference for me in this case is the table is recognized by 8.1.7 when enclosed in "" (double quotes) whereas not at all in 8.1.6. The 8.1.7 after addition of double quotes lets do all SQL functionality with the table.
For Ex:
Insert into "temp1" values (10, 'Michelle');
commit;
select * from "temp1";
works very fine, just as normal table.
My Question is : Is is actually a difference in the versions or is it a installation glitch or any other explanation to this available ?
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
