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
- 17465 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?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!
can any one help me with import/export options in oracle............
What does sharding mean?
How to define a data source name (dsn) in odbc manager?
How to update values on multiple rows in oracle?
How to define a procedure inside another procedure?
What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?
Explain the family trees and connection by clause
What is schema?
41 Answers Bodhi Global Services, Cognizant, HCL,
How to list all user accounts in oracle?
Oracle General 
