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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is data block in Oracle?

615


normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

1736


What are the general rules on data consistency?

585


What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

520


What is ceil and floor in oracle?

569






Are truncate and delete commands same? If so why?

646


What is oracle update statement with inner join ?

577


Explain parameter file in oracle.

574


What do you mean by merge in oracle and how can you merge two tables?

522


How can we force the database to use the user specified rollback segment?

554


What is the difference between primary key and unique key and foreign key in oracle?

544


Explain the difference between a procedure and a function?

553


How to pass a parameter to a cursor in oracle?

591


How to pass parameters to procedures?

553


Can multiple cursors being opened at the same time?

605