Most read

5 ways to delete duplicate records in Oracle
Install Notepad++ in Ubuntu
5 ways to test Oracle RefCursor results
Oracle interview questions and answers
Nth highest salary 
Difference between Trunc and Round function
Notepad++ – Tips and Tricks
Oracle PL/SQL interview questions and answers

All Posts

Memory test for Browsers in Ubuntu
Latest version of Oracle database – Oracle 12c
Force quit Ubuntu 12.04
Install Gimp 2.8 in Ubuntu
Remote desktop in ubuntu 12.04
Install Skype in Ubuntu
Install Google Earth in Ubuntu 12.04 – 3 Steps
Ascii Chart using  Oracle
How to find version of Oracle
Install Microsoft fonts in Ubuntu 12.04
How Ubuntu assign version names ?
Ubuntu 12.10 Quantal Quetzal – New Features
Window 8 new features
32 bit or 64 bit
Install oracle 11g on windows 7
Installing Oracle 11g on Ubuntu
Install LAMP on Ubuntu Desktop
Show Desktop in Ubuntu 12.04
Firefox 13 available for Ubuntu 12.04


Constraints Examples
Cursor Basics
Cursor examples
Select 5 ways to delete duplicate records
Julian date
Polymorphism or Operator overloading in Oracle
Oracle 12c new features
LEAD function and LAG function
BITAND function
SOUNDEX function
TO_CHAR (number) function
FIRST_VALUE and LAST_VALUE analytical functions
Single quote manipulation
Replace, Translate and Compare Replace and Translate
Merge statement
Simple debugging tool Oracle
dbms_output package
Greatest and Least function
Difference between TRUNC and ROUND functions
Numeric Functions Oracle
For loop, While loop, goto statement
Ascii table
Difference between UNION and UNION ALL
Autonomous Transaction
Oracle interview questions and answers
Oracle NVL2
Oracle Sequence
Alter table
Compare DECODE and CASE
Oracle CASE statement
Oracle INSTR function
Oracle SUBSTR function
Oracle NVL function
Oracle NULL
Oracle DECODE function
Nth highest salary
Oracle DENSE_RANK function
Oracle RANK function
Oracle SUM function
Oracle REMAINDER function
Oracle MOD function
Oracle ABS function
Oracle Subquery
Oracle SOME operator
Oracle ANY operator
Oracle IN operator
Oracle COUNT function
Oracle AVG function
Oracle MIN function
Oracle MAX function


Login MySQL command line
Oracle NVL equivalent in MySQL
MySQL SUBSTR function

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s