can we insert any row to dual table if i got the permission
from DBA
Answer Posted / 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 View All Answers
what are archived logs?
How to get a create statement for an existing table?
Give the advantages and disadvantages of clusters.
How to work with data objects interactively?
How to convert a date to char in oracle? Give one example.
How will you write a query to get a 5th rank student from a table student_report?
11. Display the client number and name and the client number and name of the person who referred that client.
Why use resource manager in Oracle?
How to return top 5 rows in oracle?
How to write a query with a right outer join in oracle?
How to convert characters to times in oracle?
What types of joins are used in writing subqueries?
What are the attributes of cursor?
How to calculate date and time differences in oracle?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?