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

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

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

what is row chaining and row migration?

2 Answers Wipro,

hai what are the certification courses available in oralcle certification

1 Answers

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

0 Answers Accenture,

I would like to know all the details about oracle certification on different levels.

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

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,

can u provide sql dumps for my certification?

31 Answers Adasoft, Oracle,

how can i get oracle certifications logo?

2 Answers

Sir, what are the certification courses available in peoplesoft. I have completed my B.com (1991) and currently working in IT sector on peoplesoft financial module.where i can do this certification.

0 Answers

i want to do oracle certification..could any one pleas tell me what is the level 1 certification exam in oracle? how do we get dumps?

0 Answers

For more Oracle Certifications Interview Questions Click Here