Welcome Guest ( Log In | Register)



 
Reply to this topicStart new topic
> Oracle Tables, Interesting feature
cse-icons
post 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,
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. C Code, Can U Solve This?(22)
  2. Crazy Looking C Program(19)
  3. Download Movies - Free, Legally!(55)
  4. What Is A Chupacabra?(98)
  5. Connect To Remote Oracle Database With Toad(7)
  6. Swastika Shaped Building In San Diego(10)
  7. Fp2003 - Tables(7)
  8. Connecting Php With Oracle Database(1)
  9. Wikipedia + Myspace = ...(38)
  10. Dynamically Select From 2 Tables Based On Id(1)
  11. Compare 2 List Of User Ids From Different Tables(1)
  12. 'guitar Hero Iii: Legends Of Rock' (some Interesting News)(0)
  13. How To Enable Or Disable Highlight Programs Feature In Start Menu(3)
  14. Align Text Column Without Tables Using Css(13)
  15. Can You Put Tables Inside Of Tables?(6)
  1. Ashes(5)
  2. Indonesia(6)
  3. An Interesting Approach To Email Verification...(6)
  4. Getting Started With Mysql(2)
  5. Beautiful Feature Added By Facebook >(2)
  6. Oracle Clinical(0)
  7. How To: Html Tables.(8)
  8. An Interesting Video, A Must See(1)
  9. "register.php"(11)
  10. Enzymes And Health(0)
  11. Animal Orientation Behavior(4)
  12. PHP Function To Add Previous and Next Page Feature(2)
  13. Your Favorite Actors(1)


 



- Lo-Fi Version Time is now: 8th September 2008 - 02:39 PM