SQL>select 'yakub' pasha from dual; (what is the output and how it

SQL>select 'yakub' pasha from dual;
(what is the output and how it happen)

Question Posted / yakub2indian

3 Answers
6453 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

SQL>select 'yakub' pasha from dual; (what is the output and how it happen)..

Answer / sudheer d

Is This Answer Correct ?

14 Yes

0 No

SQL>select 'yakub' pasha from dual; (what is the output and how it happen)..

Answer / rohit kumar upadhyay

yakub

Is This Answer Correct ?

3 Yes

1 No

SQL>select 'yakub' pasha from dual; (what is the output and how it happen)..

Answer / venu

it will return pasha as the column heading & yakub as the
record row selected.
dual is a single row dummy table.
it phisically not exist in database,
but work as a single row temp table to get instant result
witout any table,which is several times very usefull to
test result on single row.
ex: cheking the functions on single row before goint to
impliment on tables
sql> select upper(hai) from dual
/
sql>select sysdate from dual
/
etc

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More Oracle Certifications Interview Questions

How to specify multiple value

2 Answers

I have done GNIIT software engneering and B.COM and also i have 1yr exp in oracle DBA can i do oracle DBA certification plz adviced me frnds....as early possible with certification details...

0 Answers TCS,

Hi guys, I want to clear exams of OCA and informatica developer (three papers).......Could you all plz help me and send me the dumps for the same...Thanks in advance!!!!

0 Answers

Dumps for 1z0-108 Weblogic server administration 11g or 1z0-102 Weblogic server administration 10g

1 Answers Cognizant, Verizon,

Does any one have oracle dumps for this exam - 1Z0-147: Program with PL/SQL ?

0 Answers

I have b licence . I want c licenc. What can i do it. I have 5 years HT experience .

0 Answers TNEB Tamil Nadu Electricity Board,

Hi , I am planning to take up OCA certification in next 3 months.Can you please provide me with the path for Oracle DBA certi.If any one of you have dumps for same,please mail them to mukund.kanabargi@gmail.com.Please give me any tips if possible.

1 Answers

hello every one..I am preparing for OCA exam.can any body tell me where i can get the material.plez send me if u have material to prdp_ramagiri@yahoo.co.in

1 Answers Oracle,

i would like to know oracle dba on 10g/11i certification fee structure ..for all exams please help me

3 Answers CTS, Oracle,

What is the default value of Boolean Operator? a.Null b.True c.False d.none of the above

15 Answers CTS, Infosys, Wipro,

hi thiz is rahul i want to do my ocp certification can any one plz guide me with full details

0 Answers

Hi, I am planning for oracle datawarehousing fundamentals 11g certification.. 1Z0-515.. Any having dumps or materials for this.. pls provide me..

0 Answers BirlaSoft,

For more Oracle Certifications Interview Questions Click Here