SQL>select 'yakub' pasha from dual;
(what is the output and how it happen)
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
im prepare the OCE exam. i have no idea wat the procedure.plz give me some suggestions
How the text files in the operating system are accesed through UTL_FILE package, if the user have no access to operating system.
Hi, I am planning for oracle datawarehousing fundamentals 11g certification.. 1Z0-515.. Any having dumps or materials for this.. pls provide me..
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.
Can any one provide dumps for Oracle Fusion CRM certification (1Z1-456)
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?
I would like to know about Oracle Online Course certification (Finance)
what is the exact syllabus for oracle certification level 1?
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.
hi thiz is rahul i want to do my ocp certification can any one plz guide me with full details
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.
Does any one have oracle dumps for this exam - 1Z0-147: Program with PL/SQL ?
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.
Hi, I am doing mba hr and having 4.4 yrs experience in marketing research and accounts payable together. Now i have 2 yrs of carrier break. Will it be advisable to do oracle hrms certification and grab new opportunities?
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.