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
- 17314 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 relation of a user account and a schema in oracle?
ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?
when loggined as SYSTEM,how to display all the users of database using sql query?
State all possible different index configurations a table can possibly have?
How to handle a single quote in oracle sql?
what are pseudocolumns?
Why do you use stored procedures and state some of its disadvantages?
Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What is the disadvantage of User defind function?
What is a sub query and what are the different types of subqueries?
How to find no of saturdays in a month using single sql ?
Oracle General 
