| |
GeekInterview.com > Interview Questions > Oracle > SQL
| Print | |
Question: can we insert a record in dual?
|
| July 07, 2008 05:51:45 |
#2 |
| krishnaveni_g |
Member Since: July 2008 Total Comments: 9 |
RE: can we insert a record in dual?
|
Dual is a default table it contains one row, one column. But we can create table like dual and insert records in that table
create table dual(name varchar2(20));
insert into dual values('Rushi');
commit;
Select * from dual;
It will show Rushi
select sysdate from dual;
This will show result from default dual table
|
| |
Back To Question | |
