Answer / ram babu mandal(software engin

Yes, first I connect the as sysdba after that we insert
data in the dual table as

sql>conn / as sysdba
connected
sql>desc dual;
insert into dual values('A');
(1)row inserted

but I found some problems after that ,We use
sql> seelct * from dual;

Only one value displayed
that was default 'x' as system defined data not displayed
other data a like 'A'.


Dummy
-------
x

Only x record display in the dual table.

Answer / neo devan

No, its a system table defined by oracle.
Even the DBA has read privileges for dual table.

Answer / kiran

yes why not . you can insert values and see the values also

but a caviet you can only insert 1 value

its has datatype with length 1

varchar2(1)

Answer / chandana

Dual is a pseudotable with one column varchar and length=1.
Yes, we can insert values into Dual table provided the
inserted value is of type varchar and length =1.

Answer / sanjay gupta

U can by connecting as sysdba

but it displays all rows

insert into dual values('A');
insert into dual values('B');
commit;
select * from dual;
Dummy
-------
x
A
B
in same session and will display x in different session only

if you ctreate table identity

0 Answers  

how can we store any pdf file in oracle

0 Answers  

Which Department has MOST NUMBER of employees?

8 Answers   IBM, LeadSquared, Mastek,

What is an external table?

0 Answers  

What is a initialization parameter file in oracle?

0 Answers  

What are the different pseudo commands? Explain in general?

0 Answers  

How to create a new table in your schema?

0 Answers  

Explain the difference between replace() and translate() functions in oracle?

0 Answers  

How to create an oracle database manually?

0 Answers  

what are archived logs?

0 Answers  

SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me

6 Answers   TCS,

Explain what are clusters?

0 Answers