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

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

0 Answers

Hi All..! This is Ratna,Im working as a Oracle apps Technical Consultant with 2yrs of experience.I started working on Hrms module,I feel like going for functional certification in HRMS module.Can any one suggest me on the below questions 1. how many papers are there for Oracle HRMS certification, and what is fees for each paper. 2. can a person pass the paper by reading the related documention provided by oracle. 3. do anybody have bunch of questons for oracle HRMS and like to share.

0 Answers IBM, NIIT,

where the bestone of the oracle certification tutorials in the hyderabad plz give me full contact address to my ramu.nani28@gmail.com thank you frnds

1 Answers Oracle,

Can you pls tel me there is any certification for Peoplesoft hrms?

1 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

I am planing for sql exam so please help me about exam questions.

1 Answers

Hi, I am planning for oracle datawarehousing fundamentals 11g certification.. 1Z0-515.. Any having dumps or materials for this.. pls provide me..

0 Answers BirlaSoft,

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

1 Answers

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

0 Answers

I would like to know about Oracle Online Course certification (Finance)

0 Answers Accenture,

hello every one..I am preparing for OCA exam.can any body tell me where i can get the material.plez send me if u have material to prdp_ramagiri@yahoo.co.in

1 Answers Oracle,

hi thiz is rahul i want to do my ocp certification can any one plz guide me with full details

0 Answers

For more Oracle Certifications Interview Questions Click Here