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
5143 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 am willing to go for General Ledger certification. Could any one guide me what are the prerequisites..? am i need to any exam before take this GL exam..?

1 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

im prepare the OCE exam. i have no idea wat the procedure.plz give me some suggestions

0 Answers HCL,

hai, i think to do certification in oracle 11i. Can any one help me regarding fee, duration , preparation, and how much it is use full for getting a good job.

0 Answers

can u provide sql dumps for my certification?

31 Answers Adasoft, Oracle,

1)Can Any body tell total no. of question in OCA and OCP? 2)Can i directly appear the OCP exam without attending OCA exam?

4 Answers Infosys, Oracle,

hai what are the certification courses available in oralcle certification

1 Answers

sir plse tell me oracle 10g ocp certification material and previous papers send to me

1 Answers

Hi. I wish to appear for OCA exam. Can anyone pls guide me on the syllabus n fee structure of the exam. I know that there are 2 tracks : developer and dba. What is the difference between the two? All suggestions are welcome. Thanks.

0 Answers Aptron, Syntel,

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

hi, i did ocp dba 9i in 2009 but not get job on oracle,now i want to continue my career as oracle dba what i do next .?

0 Answers

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

0 Answers

For more Oracle Certifications Interview Questions Click Here