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

Hi, I am doing mba hr and having 4.4 yrs experience in marketing research and accounts payable together. Now i have 2 yrs of carrier break. Will it be advisable to do oracle hrms certification and grab new opportunities?

0 Answers

How to prepare for doing OCA and is there books or any model questions or any site which helps us fro preparing our own? Please give me the complete information if possible.

2 Answers

What is the exam fees for oca,ocp,ocm certification course in Bangalore?

1 Answers Oracle,

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,

Can any one provide dupms for Oracle Business Intelligence Applications 7 for CRM Essentials certification exam(1Z0- 524)

1 Answers TCS,

explain procedure of the OCJP cerification, and exam fee please explain

0 Answers

how can i get oracle certifications logo?

2 Answers

hello friends. i m saravanan. my stream (B.Tech)Information Technology. i m seeking for job. now i plan to do informatica certification.. but this certification is only for experienced software professional. i m having no software experience. do u think is informatica certification is useful to my carrer..?? and pls explain which certification is better Oracle (Or) Informatica????? my mail id is ysaravananbtech@gmail.com mobile no is>> +91-9894060089

0 Answers Wipro,

basically oracle i dont know .so what kind of courses and how to prepare and where to write a exams and fees detaile and it features sent to friends or sir or madam

2 Answers Oracle, Tech Mahindra,

I completed MCA and also I have OCA certification. Now I am working as a Application Developer in Asp.net but I need a job in Oracle Application or related to Sql or Pl/Sql.

0 Answers

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

I would like to know passing marks for oracle certification course module 1....

1 Answers

For more Oracle Certifications Interview Questions Click Here