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
- 17064 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 |
Explain the use of Merge statement in oracle 11g
You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?
How to build data dictionary view an new database?
Is there a combination of "like" and "in" in sql?
What are the advantages of oracle 12c?
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
Does a Before form trigger fire when the parameter form is suppressed ?
find out the second highest salary?
55 Answers Cognizant, Nucsoft, Oracle, TCS, Wondersoft,
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
How to join two tables in a single query using oracle?
How to initialize variables with default values?
what is a view?
Oracle General 
