YouOracle

DECODE(expression, searchedValue, returnValues ...) function is used to search a value in a column or expression as it is done in IF-ELSE st...

NULLIF(a, b) function compares a and b, if they are equal then it returns NULL, else returns a. SELECT NULLIF('Zeynal', name) FROM...

We can get current database name from select v$database table. SELECT name FROM v$database;

Example: Create role named changer on table students that will be able to update it. And give this role to user zeynal and david . CREAT...

Example: Get SELECT, UPDATE privileges on students table back those were given to user zeynal . REVOKE SELECT, UPDATE ON students FROM ze...