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
- 6673 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
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.
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.
explain procedure of the OCJP cerification, and exam fee please explain
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.
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?
Hi, I am planning for oracle datawarehousing fundamentals 11g certification.. 1Z0-515.. Any having dumps or materials for this.. pls provide me..
hello friends. i m saravanan. my stream (B.Tech)Information Technology. i m seeking for job. now i plan to do informatica certification.. but this certification is only for experienced software professional. i m having no software experience. do u think is informatica certification is useful to my carrer..?? and pls explain which certification is better Oracle (Or) Informatica????? my mail id is ysaravananbtech@gmail.com mobile no is>> +91-9894060089
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.
hi thiz is rahul i want to do my ocp certification can any one plz guide me with full details
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...
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 .?
How the text files in the operating system are accesed through UTL_FILE package, if the user have no access to operating system.
being in business intelligence and data warehousing,what would be the importance of a oracle certification how much would it cost me
I have b licence . I want c licenc. What can i do it. I have 5 years HT experience .
what is the exact syllabus for oracle certification level 1?
