can we insert any row to dual table if i got the permission from DBA

Advertise your Business Here

Refer this Site

Login | Sign Up


	SiteMap shows list of All Categories in this site.

Categories >> Software >> Databases >> Oracle >> Oracle General

Oracle General Interview Questions

OCI Interview Questions

Architecture Interview Questions

Oracle Security Interview Questions

Database Management Interview Questions

Forms Reports Interview Questions

Oracle AllOther Interview Questions

Question

can we insert any row to dual table if i got the permission 
from DBA

Question Submitted By :: Aliya

I also faced this Question!!

Rank

Answer Posted By

Re: can we insert any row to dual table if i got the permission from DBA

Answer
# 1

No, its a system table defined by oracle.
Even the DBA has read privileges for dual table.

Is This Answer Correct ?

17 Yes

12 No

Neo Devan

Re: can we insert any row to dual table if i got the permission from DBA

Answer
# 2

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 ?

9 Yes

2 No

Ram Babu Mandal(software Engin

Re: can we insert any row to dual table if i got the permission from DBA

Answer
# 3

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 ?

3 Yes

0 No

Kiran

Re: can we insert any row to dual table if i got the permission from DBA

Answer
# 4

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 ?

2 Yes

0 No

Chandana

Re: can we insert any row to dual table if i got the permission from DBA

Answer
# 5

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

7 No

Sanjay Gupta

Question	Asked @	Answers
Other Oracle General Interview Questions


after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble		1
9. Display the client name and order date for all orders using the JOIN . . . USING method.	Wipro	2
14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth	Wipro	1
What is DTS and purpose of DTS ?	TCS	1
how to get last monday of a month?	Multifonds	2
sql command 2 know current database		4
what is a cartition product?		4
12 RULES OF RDBMS		1
What is an Index ?		2
I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.	Microsoft	5
Describe the different type of Integrity Constraints supported by ORACLE ?		1
Shall I get Pro*C Compiler in Oracle-10g release ?		1

For more Oracle General Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2012 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com