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
6460 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 would like to know all the details about oracle certification on different levels.

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

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

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

1 Answers Cognizant, Verizon,

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

Can anyone plz let me know the output for this query? select 1 from dual minus select 'a' from dual;

2 Answers

hai what are the certification courses available in oralcle certification

1 Answers

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

0 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,

How to specify multiple value

2 Answers

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

1 Answers Oracle,

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,

hai what are the certification courses available in oralcle certification

1 Answers

For more Oracle Certifications Interview Questions Click Here