Code Snippet

Just another Code Snippet site

database

[Oracle] DENSE_RANK

DEPARTMENT_NAME LAST_NAME SALARY DRANK ———————– —————— ———- ———- Purchasing Colmenares 2500 1 Purchasing Himuro 2600 2 Purchasing Tobias 2800 3 Purchasing Baida 2900 4 Purchasing Khoo 3100 5 Purchasing Raphaely 11000 6 Human Resources Marvis 6500

,

[Oracle] How-To

Retrieve the name of the Oracle instance currently connected to : Starting database with PFILE/SPFILE : Create an ini file (init$ORACLE_SID.ora) with :

,

Previous Posts Next posts