SQL - can we insert a record in dual?

GeekInterview.com > Interview Questions > Oracle > SQL

Go To First | Previous Question | Next Question

SQL | Question 163 of 168

can we insert a record in dual?

Total Answers and Comments: 3

Last Update: August 16, 2008 Asked by: ashish88

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

June 20, 2008 01:36:58

ashish88

Member Since: June 2008 Contribution: 8

RE: can we insert a record in dual?

yes i can insert a record in dual
to use this command
CREATE TABLE DUAL(COL1 VARCHAR(1));
select sysdate from dual
insert into dual values('X')
commit
insert into dual values('X')

to use and show the result

hope this Help You
Ashish Sharma

Is this answer useful? Yes | No

0 1

Overall Rating: -1

July 11, 2008 05:51:45

krishnaveni_g

Member Since: July 2008 Contribution: 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

Is this answer useful? Yes | No

August 15, 2008 14:16:40

spohilko

Member Since: August 2008 Contribution: 1

RE: can we insert a record in dual?

The answer depends on release. Before 10g it was possible, starting with 10g - no.

Is this answer useful? Yes | No

Go To Top