Interested to Buy Any Domain ? << Click Here >> for more details...
can we insert any row to dual table if i got the permission
from DBA
- 5 Answers
- 17052 Views
- HCL, Tesco, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
Please explain oracle data types with examples?
what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .
What is an UTL_FILE.What are different procedures and functions associated with it?
Select the Nth lowest value from a table?
What is a materialised view?
What is a private synonym?
How to set a transaction to be read only in oracle?
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
Differentiate between post-database commit and post-form commit?
How can we find the size of a database?
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
How to create a table index?
Oracle General 
