| wild card filtering [message #20335] |
Tue, 14 May 2002 13:58  |
ckr
Messages: 13
Registered: May 2002
|
Junior Member |
|
|
is there any reason why wildcard filtering('_') does not work for some tables? i copied a set of tables from a book.surprisingly this '_' wildcard filtering is not working only for those tables i have copied.it is working with other tables which i have created.
is there any reason for this?
|
|
|
|
| Re: wild card filtering [message #20341 is a reply to message #20335] |
Wed, 15 May 2002 05:35  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
Try double quoting it.
create table _EMP (col1 number);
ORA-00911: invalid character
create table "_EMP" (col1 number);
Table created
drop table "_emp";
ORA-00942: table or view does not exist
drop table "_EMP";
Table dropped
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
