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
6352 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'm jhaniya i'm a fresher i've completed course in informatica and cognos but yet nw i din get a job ..so planning to study oracle will tis match ..even if i get placed in oracle can i then get into informatica wil this work out ..which part can i choose in oracle ..

3 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

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

2 Answers IBM,

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

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

I am willing to go for General Ledger certification. Could any one guide me what are the prerequisites..? am i need to any exam before take this GL exam..?

1 Answers

What is the exam fees for oca,ocp,ocm certification course in Bangalore?

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, i think to do certification in oracle 11i. Can any one help me regarding fee, duration , preparation, and how much it is use full for getting a good job.

0 Answers

hai what are the certification courses available in oralcle certification

1 Answers

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

2 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

For more Oracle Certifications Interview Questions Click Here