Interested to Buy Any Domain ? << Click Here >> for more details...
SQL>select 'yakub' pasha from dual;
(what is the output and how it happen)
- 3 Answers
- 6293 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
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...
Does any one have oracle dumps for this exam - 1Z0-147: Program with PL/SQL ?
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.
Hi, I am planning for oracle datawarehousing fundamentals 11g certification.. 1Z0-515.. Any having dumps or materials for this.. pls provide me..
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?
How the text files in the operating system are accesed through UTL_FILE package, if the user have no access to operating system.
Can any one provide dumps for Oracle Fusion CRM certification (1Z1-456)
hi thiz is rahul i want to do my ocp certification can any one plz guide me with full details
im prepare the OCE exam. i have no idea wat the procedure.plz give me some suggestions
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.
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.
being in business intelligence and data warehousing,what would be the importance of a oracle certification how much would it cost me
I would like to know about Oracle Online Course certification (Finance)
explain procedure of the OCJP cerification, and exam fee please explain
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 .?
