can we insert any row to dual table if i got the permission from DBA

Categories >> Software >> Databases >> Oracle >> Oracle General
Suggest New Category

can we insert any row to dual table if i got the permission
from DBA

Question Posted / aliya

5 Answers
15460 Views
HCL, Tesco, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

can we insert any row to dual table if i got the permission from DBA..

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.

Is This Answer Correct ?

10 Yes

2 No

can we insert any row to dual table if i got the permission from DBA..

Answer / neo devan

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

Is This Answer Correct ?

18 Yes

13 No

can we insert any row to dual table if i got the permission from DBA..

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)

Is This Answer Correct ?

4 Yes

0 No

can we insert any row to dual table if i got the permission from DBA..

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.

Is This Answer Correct ?

4 Yes

0 No

can we insert any row to dual table if i got the permission from DBA..

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

Is This Answer Correct ?

1 Yes

10 No

Post New Answer