can we insert any row to dual table if i got the permission
from DBA
Answer Posted / 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 |
Post New Answer View All Answers
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
Can we write insert statement in function in oracle?
How to use "out" parameter properly?
Why packages are used in oracle?
How to drop an index?
What is the sid in oracle?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
How to synchronize 2 schema's objects?
How can windows applications connect to oracle servers?
What is redo log?
List the parts of a database trigger.
What are the database administrators utilities available?
What is transaction control statement and how many types of transaction control statement in Oracle?
What is a cursor variable?
Explain mutating triggers.