Oracle Tables Interesting feature

[cse-icons 0]

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).

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.

insert into " " values(3);

To access such a table use

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,