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

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,

i required oracle HRMS certification material , if your friends or your colleagues have this material , then pl send me ... or either you find any where in website then send me links

0 Answers

what is the exact syllabus for oracle certification level 1?

0 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 completed MCA and also I have OCA certification. Now I am working as a Application Developer in Asp.net but I need a job in Oracle Application or related to Sql or Pl/Sql.

0 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

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,

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

0 Answers HCL,

what is the meaning of this query Alter database force logging.

1 Answers

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

0 Answers

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

For more Oracle Certifications Interview Questions Click Here