| Rush |
Posted: Mar 09, 2007 03:11:56 AM |
Total Post: 127
Joined: Jan, 2007
|
| can we create our own dual table????since it is oracle defined table to check funtionality of single row and other functions.this q was asked in an interview . |
|
|
 snehalatha |
| Posted: Mar 09, 2007 03:52:55 AM |  |
|
Total Post: 169
Joined: Apr, 2006
|
You can create a dual table and you can drop the dual also.
this is the procedure for creating dual table
SQL> create table test_dual (dummy VARCHAR2(1) Primary Key) Organization index;
Table created.
SQL> insert into test_dual values('X');
1 row created.
SQL> commit;
Commit complete.
SQL> select sysdate from test_dual;
|
|
|
|
|
| Mahesh Rajendran |
| Posted: Mar 09, 2007 01:59:49 PM | |
|
Total Post: 10
Joined: May, 2005
|
I would drop the dual table, if i would like to end up in trouble :).
Dual is a sys object. Manipulating sys objects (drop/insert/update whatever) directly means you are asking for trouble.
>>check funtionality of single row and other functions
Acutally it is more than that.
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1562813956388
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
