--Jour de naissance
SELECT SYSDATE FROM DUAL ;
SELECT TO_CHAR( TO_DATE( '22-01-2017', 'DD-MM-YYYY' ), 'DAY' ) JOURNAISSANCE
FROM DUAL;
SELECT RPAD( 'Soleil', 17, 'bla' ) "RPAD exemple" FROM DUAL;
SELECT LPAD( 'AIR1', 15, '*.' ) "LPAD exemple" FROM DUAL;
--chaines
SELECT SUBSTR( 'ABCDEFGHIJ', 6, 3) "SUBSTR exemple" FROM DUAL;
SELECT SUBSTR( 'ABCDEFGHIJ', -5, 4) "SUBSTR exemple" FROM DUAL;
SELECT TO_CHAR (SYSDATE, 'MM-DD-YYYY HH24:MI:SS' ) "Now" FROM DUAL;
SELECT LENGTH( 'WEB WAREHOUSE' ) "Nombre de caracteres" FROM DUAL;
--Arrondis
SELECT ROUND( 17.0958, 1 ) "ROUND exemple" FROM DUAL;
SELECT ROUND( 17.58, 2 ) "ROUND exemple" FROM DUAL;
SELECT TRUNC( 1958.0917, 1 ) "TRUNC exemple" FROM DUAL;
SELECT TRUNC( 1958.0917, 2 ) "TRUNC exemple" FROM DUAL;
SELECT ROUND( TO_DATE( '17-09-2016' ), 'YEAR' ) "New Year" FROM DUAL;
--Dates
SELECT TO_DATE( '17-SEPT.-2016', 'DD-MON-YYYY' ) FROM DUAL;
ALTER SESSION SET NLS_DATE_LANGUAGE = 'American' ;
SELECT ROUND(TO_DATE( '17-SEP-2016', 'DD-MON-YYYY' ), 'YEAR' ) "New Year" FROM DUAL;
ALTER SESSION SET NLS_DATE_LANGUAGE = 'American' ;
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MM-YYYY' ;
SELECT TO_DATE( '17-SEP-2016' , 'DD-MON-YYYY' ) FROM DUAL;
SELECT EXTRACT(YEAR FROM SYSDATE) FROM DUAL;
SELECT ADD_MONTHS(SYSDATE, 7 ) FROM DUAL;
SELECT TRUNC( MONTHS_BETWEEN( SYSDATE, TO_DATE( '29-MAY-2017' ) ) ) AS AGEBB
FROM DUAL;
SELECT TO_NUMBER( TO_CHAR(SYSDATE, 'YYYY' ) ) FROM DUAL;
SELECT SYSTIMESTAMP FROM DUAL;
--Sequences
CREATE SEQUENCE MY_SEQ MINVALUE 1 ;
SELECT MY_SEQ.NEXTVAL FROM DUAL;
SELECT MY_SEQ.CURRVAL FROM DUAL;
DROP SEQUENCE MY_SEQ;