CREATE TABLE diverse (
  numar NUMBER PRIMARY KEY,
  sir VARCHAR2(15) ,
  dataE date 
); -- Table created.
...........................................................
-- insert
INSERT INTO diverse VALUES (123, 'Clark Gable', TO_DATE('2003/05/03', 'yyyy/mm/dd') );
INSERT INTO diverse VALUES (2468, 'Muntii Carpati', TO_DATE('1983/05/23', 'yyyy/mm/dd') );
INSERT INTO diverse(numar,sir) VALUES (36996, 'Ava');
-- 1 row created.
.................................................
SELECT * FROM diverse;

NUMAR SIR		   DATAE
---------- --------------- ---------
       123 Clark Gable	   03-MAY-03
      2468 Muntii Carpati  23-MAY-83
     36996 Ava

............................................................

SELECT TO_CHAR(datae, 'Month dd, YYYY') AS "exemplu1"
FROM diverse where numar=24680;
no rows selected
.............................................
SELECT TO_CHAR(datae, 'fmMonth dd, YYYY') AS "exemplu2"
FROM diverse  where numar=24680;
no rows selected
..........................................
SELECT TO_CHAR(datae, 'fmMonth ddth, YYYY') AS "exemplu3"
FROM diverse  where numar=24680;
no rows selected
........................................
SELECT TO_CHAR(datae, 'fmDay ddth Mon,YYYY') AS "exemplu4"
FROM diverse;

exemplu4
-------------------------
Saturday 3rd May,2003
Monday 23rd May,1983

........................................................


SELECT TO_CHAR(datae, 'fmDay ddthsp Mon, YYYY') AS "exemplu5"
FROM diverse;

exemplu5
----------------------------
Saturday third May, 2003
Monday twenty-third May, 1983

.............................................................

SELECT TO_CHAR(datae, 'fmDay, ddthsp "of" Month, Year') AS "exemplu6"
FROM diverse;

exemplu6
--------------------------------------
Saturday, third of May, Two Thousand Three
Monday, twenty-third of May, Nineteen Eighty-Three

...........................................................
SELECT TO_CHAR(datae, 'hh:mm') AS "exemplu7"
FROM diverse;

exemplu7
-----
12:05
12:05

...........................................................

SELECT TO_CHAR(dataE, 'hh:mm pm') AS "exemplu8"
FROM diverse;

exemplu8
--------
12:05 am
12:05 am

..............................................................

SELECT TO_CHAR(dataE, 'hh:mm:ss pm') AS "exemplu9"
FROM diverse;

exemplu9
-----------
12:05:00 am
12:05:00 am
...............................................................
SELECT TO_CHAR(numar*2,'$99,999') AS "exemplu10"
FROM diverse  ;

exemplu10
--------
    $246
  $4,936
 $73,992
 ...............................................................
SELECT TO_CHAR(numar, '$99999.99') AS "exemplu11"
FROM diverse ;
exemplu11
----------
   $123.00
  $2468.00
 $36996.00
 ...............................................................
SELECT TO_CHAR(numar, '99,999') AS "exemplu12"
FROM diverse  ;
exemplu12
-------
    123
  2,468
 36,996
 ...............................................................
SELECT TO_CHAR(numar, '99,999.99') AS "exemplu13"
FROM diverse ;
exemplu13
----------
    123.00
  2,468.00
 36,996.00
 ..............................................................
SELECT TO_CHAR(numar, '0009999') AS "exemplu14"
FROM diverse where datae is not null;
exemplu14
--------
 0000123
 0002468
 ....................................................