Oracle and sql plus

OracleAndSqlPlus.sql

--ORACLE SQL DEVELOPER
--ctrl + enter - run selected statement
--F9 compile and run selected statement


--determining the current date format:
SELECT value
FROM   nls_session_parameters
WHERE  parameter = 'NLS_DATE_FORMAT'
--output: RR/MM/DD

--delcaring variable:
VARIABLE ret_val NUMBER;
BEGIN
 :ret_val:=4;
END;
/
PRINT ret_val

--