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
5155 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

i wrote my oca and ocp exam last year novemeber i got my oca certificate but havnt gotten my ocp i completed my hands-on and an email was sent to me saying my ocp will be delivered in 30days its 4months now and i have not seen my certificate.i will loose my job next month cos of that pls help me

2 Answers Cognizant, Infogain, Infosys, Ora Tech,

oracle what kind of certificate as valided in nowadays. how long during studied for this certificats.

1 Answers Oracle,

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

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

3 Answers

i have 6 years of gap after doing bca. how to get a good job now.

0 Answers IBM,

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

how can i get oracle certifications logo?

2 Answers

i want to do oracle certification..could any one pleas tell me what is the level 1 certification exam in oracle? how do we get dumps?

0 Answers

Can you please send me the dups for the OCA certification?

2 Answers IBM,

Sir, what are the certification courses available in peoplesoft. I have completed my B.com (1991) and currently working in IT sector on peoplesoft financial module.where i can do this certification.

0 Answers

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

1 Answers Cognizant, Verizon,

I would like to know all the details about oracle certification on different levels.

16 Answers Algo, CMC, CybAge, HCL, IBM, Oracle, TCS, Zensar,

For more Oracle Certifications Interview Questions Click Here