Tutorial66.com
@Share Application Development Skill.



Tutorial is tutorial...66 is My Country Code Up to 10 Years EXP for Application Development Role in Thailand.
collapse

Tutorial Category



« previous next »
Pages: [1]

Topic: What is a DUAL Table in Oracle and How to uses it  (Read 180 times)


My Development skill
Java JSP Servlet EJB
Spring Framework
Hibernate Framework
iReport Jasper Report
Apache CXF
PHP Codigniter
Oracle PLSQL
Unix Shell Script
What is a DUAL Table in Oracle and How to uses it
« on: December 28, 2011, 07:05:07 AM »
DUAL table in Oracle is dummy table for return single row

Example to use DUAL TABLE
Code: [Select]

select 1 from dual;
-- out put is 1

select sysdate from dual;
-- out put is current date

select to_char(sysdate,'dd/mm/yyyy') from dual;
-- out put is current date in format dd/mm/yyyy


You can use dual to test call Oracle function
Example use DUAL call Oracle function
Code: [Select]
select  myfunction('1')  from dual;

Logged



SimplePortal 2.3.3 © 2008-2010, SimplePortal