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

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

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

Dual is a table owned by sys user and public synonym for the same is created.
So it is available to all the users of the database.

To get the details use following query :

select * from all_synonyms  a
where a.synonym_name = 'DUAL';

By using create table to create dual table we can insert into dual .

But without creating dual we cannot insert into dual.As we didn't have insert object privilege on sys.dual table or public synonym dual.

We cannot insert, update, delete record in dual table.
Dual means dummy. In the dual table only one column is present.

You can perform any DML operations in dual table provided that you have been given the privilege to do so.
However never try to perform any DML operations (delete/insert/update) in dual table because dual is basically used to work with scalar query. If you insert any record into dual table it may stop many running applications

Dual is a Dummy table when we execute query..

Code
SELECT * FROM dual it will SHOW ..     DUMMY
                                                   X             

It has Public synonym named DUAL thats why it is accessible from any session in any schema and there is only SELECT privilege is granted on dual thats why DML cannt be fire on DUAL table ... by- Niranjan Dubey