hello dual is a table which is created by oracle along with the data dictionary. It consists of exactly one column whose name is dummy and one record. The value of that record is X. sql> desc...
Hi,Actually what happens when we issue create database command, Oracle automatically creates the tablespace and tables using the sql.bsq script found in the $oracle_home/rdbms/admin directory this scripts the dual table and is owned by the sys and has one column and one row.
DUAL is a special one-row and 1-column table having value "X" by default in Oracles SYS schema.
This table can be used for the purpose of :
1. Calculating mathematical expressions like:
SELEC...
shadiq
Jun 25th, 2015
Insert into dual values (Y); will work i guess, only thing is you need a sufficient privilege...
Also Dual can have 1000 columns and only one row.
Hi friendsQTP supports dynamic objects,but winrunner does't support.,winrunner 8.0 supports .net applications also.and the main difference i think is Run time settings.