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

How to specify multiple value

2 Answers

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 have done GNIIT software engneering and B.COM and also i have 1yr exp in oracle DBA can i do oracle DBA certification plz adviced me frnds....as early possible with certification details...

0 Answers TCS,

i would like to know oracle dba on 10g/11i certification fee structure ..for all exams please help me

3 Answers CTS, Oracle,

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

2 Answers IBM,

I am an engineering student and this is my final year. so i m planing of doing OCA certification course. is this time good? are there future scope for it?

1 Answers Oracle,

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

15 Answers CTS, Infosys, Wipro,

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 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 planning to take up OCA certification.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 sajagporwal123@gmail.com.Please give me any tips if possible.

0 Answers

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

1 Answers TCS,

For more Oracle Certifications Interview Questions Click Here