SQL & PL/SQL

SQL and PL/SQL Articles

Using Regular Expressions in Oracle

articles: 
arun_kumar_a's picture

RECYCLEBIN in Oracle

articles: 

Random Password Generator with a template

articles: 

Original blog post in here.

Give the password template to this function and get random password. It acts like dbms_random.string() function but takes more than one character as a parameter.

Here is a scenario (template)
- First char must be UPPERCASE
- Second and third one must be NUMBER
- Make fourth a NON-ALPHANUMERIC character
- Fifth one must be LOWERCASE
- Sixth is a NUMBER again
- Seventh is any character

Killing users sessions in oracle

articles: 

Dynamic SQL - for newbies

articles: 

TRUNCATE

articles: 

Killing Sessions In Oracle

articles: 

Pages

Subscribe to RSS - SQL & PL/SQL