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
- 17265 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 |
What is the difference between a hot backup and a cold backup in oracle?
What are the advantages of oracle 12c?
i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table
what are steps for interface? where is exchange rate defined in which table?
How to handle a single quote in oracle sql?
How to get execution path reports on query statements?
what's query optimization and without use of IN AND Exist can we get another way data from query
Explain mutating triggers.
How to use subqueries with the in operator using oracle?
i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?
How do I spool in oracle?
How to count groups returned with the group by clause in oracle?
Oracle General 
