в 13:45, 26 мая 2010

2010-05-26T13:45:19Z

Admin: 1 версия

2010-05-26T09:54:57Z

1 версия

Новая страница

==Do simple calculation by using dual==



<source lang="sql">

SQL>
SQL> select 123 * 456 from dual;
123*456
----------
56088
SQL>
SQL> select sysdate from dual;
SYSDATE
----------
26-10-2009
SQL>

</source>

==SELECTING FROM DUAL==



<source lang="sql">

SQL>
SQL> DESC DUAL;
Name Null? Type
----------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------------------------------------------------
DUMMY VARCHAR2(1)
SQL> SELECT * FROM DUAL;
D
-
X
1 row selected.
SQL>
SQL> SELECT 18*1.05 FROM DUAL;
18*1.05
----------
18.9
1 row selected.
SQL>
SQL> select "ABC" from dual;
"AB
---
ABC
1 row selected.
SQL>
SQL> select "A" || "B" from dual;
"A
--
AB
1 row selected.
SQL>

</source>

==The DUAL Table==



<source lang="sql">

SQL>
SQL>
SQL> --The DUAL Table
SQL>
SQL> DESC dual;
Name
-----------------------------
DUMMY
SQL>

</source>

← Предыдущая	Версия 13:45, 26 мая 2010
(нет различий)

Oracle PL/SQL/Table/DUAL Table - История изменений

в 13:45, 26 мая 2010

Admin: 1 версия