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
- 17455 Views
- HCL, Tesco, I also Faced
- E-Mail Answers
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 the benefits of ordbms?
How would you go about verifying the network name that the local_listener is currently using?
What privilege is needed for a user to connect to oracle server?
Name the various constraints used in oracle?
how to do daily transactions with out sql* loader control file regesterd in apps?
what is the scripts in data base?
How do we display rows from the table without duplicates?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
what is IDE,DMV in sql server?
What is the usage of control file in oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
How to store pictures on to the database?
How to join two tables in a single query using oracle?
How to convert a date to char in oracle? Give one example.
What is a sub query? What are its various types?
