|
|
|
|
![]() ![]() |
Jan 24 2005, 01:02 PM
Post
#1
|
|
|
Super Member ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Group: Members Posts: 351 Joined: 19-October 04 From: India Member No.: 1,824 |
hi friends,
I wud like to share this interesting piece of info that I got from a friend of mind: its possible to create tables with no names i.e. a table with spaces as its name (unfortunately). CODE Create table " " (EMPNO NUMBER(3)); creates a table with 4 spaces as its name. When you select the list of tables from all_tables, such tables are not visible. CODE insert into " " values(3); To access such a table use CODE Select * From " "; (Remember you need to give exactly the same number of spaces as you gave while creating the table). This feature can be used to store information that you feel is confidential for you. This should work in ORACLE. dont know abt others. Regards, |
|
|
|
![]() ![]() |
Similar Topics
|
Lo-Fi Version | Time is now: 8th September 2008 - 02:39 PM |