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
6676 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 planning to write OCP Certification (Oracle Functional) Here i need to complete 4 exams like 1Z0-200--Oracle eBusiness Fundamentals 1Z0-211--Oracle General Ledger Fundamentals (After this i need submitt Hands on Course form) 1Z0-212--Oracle Payable Fundamentals 1Z0-213--Oracle Receivable Fundamentals My question is what is Hands on course form and any training i need attendig? and when i have to attend between above exams?. Please suggest. Thanks

2 Answers

HI, I have completed my B.com and MBA and currently working in IT sector in HR Recruitment. i just wanted to know Oracle HRMS course is technical or functional. And is there is any study center in Noida from where i can do this certification.

2 Answers

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

is any oracle education partner in Bangalore?

5 Answers

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

1 Answers Cognizant, Verizon,

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,

what is row chaining and row migration?

2 Answers Wipro,

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

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

15 Answers CTS, Infosys, Wipro,

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

0 Answers HCL,

hi i'm jhaniya i'm a fresher i've completed course in informatica and cognos but yet nw i din get a job ..so planning to study oracle will tis match ..even if i get placed in oracle can i then get into informatica wil this work out ..which part can i choose in oracle ..

3 Answers

How the text files in the operating system are accesed through UTL_FILE package, if the user have no access to operating system.

0 Answers

For more Oracle Certifications Interview Questions Click Here