Home

Most read

Install Oracle 11g in Ubuntu
Install Oracle 11g in Windows 7
Install Notepad++ in Ubuntu
Notepad++ – Tips and Tricks
Latest version of Oracle database – Oracle 12c
Oracle 12c new features
Remote desktop in Ubuntu 
Install Microsoft fonts in Ubuntu
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

Oracle

Joins
Constraints
Constraints Examples
PRAGMA RESTRICT_REFERENCES
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 COALESCE
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

MySQL

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

2 Responses to Home

  1. If some one wants expert view on the topic of blogging and site-building after
    that i advise him/her to visit this webpage, Keep up the good work.

  2. I found your blog while I was looking for cartilage jewelry and I admit that I was incredibly
    fortunate for doing so. I believe that this is a extremely wonderful post you got here.
    Would you mind if I share site on mmy fb with your url and the title of
    your article:”sqlandplsql.com | Oracle, PL/SQL, SQL, MySQL, Ubuntu and more”?

    Cheers!!
    Our Earrings for Cartilage Group

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