Oct 312014
 
Incredible Photos You Would Love to See

  This Is Only One Picture   The Runway at the Gibraltar International Airport Has a Road Crossing It   Sunset and Eclipse Happening at the Same Time   Path-Laying Machine   Dubai in 1990 Above Dubai, from the Same Perspective, in 2008     World’s Deepest Swimming Pool – 113 Ft. Deep and Holding

[Read More]
Oct 302014
 
Loading DAT Files through SQL Loader Using TOAD

In order to import DAT file into Oracle table through TOAD follow following steps: Step1: Create Table “Employee” as below: CREATE TABLE EMPLOYEE (   EMPNAME  VARCHAR2(100 BYTE),   SALARY   NUMBER ); Step 2: Create one DAT file with name “Insert_Employee_Data.dat” containing data of Employee table for insertion and save it in D:\ drive as

[Read More]
Oct 292014
 

ROW_NUMBER is a built-in Oracle function that assigns unique number to each row it is applied to. Through ROW_NUMBER function you can add sequence number to row data, can fetch rank-wise data, and can also apply conditions to the data fetched. Syntax: ROW_NUMBER() OVER () To understand better the use of ROW_NUMBER consider following example:

[Read More]
Oct 272014
 

To find the difference between RANK () and DENSE_RANK consider Following Example: Step1: Create Table “Employee” as below: CREATE TABLE EMPLOYEE (   EMPNAME  VARCHAR2(100 BYTE),   SALARY   NUMBER ); Step 2: Insert few Records into “Employee” Table: insert into Employee values (‘John’, 500); insert into Employee values (‘Bill’, 1000 ); insert into Employee values

[Read More]
Oct 272014
 

Follow following two examples to find the exact result for 2nd highest or Nth Highest salary in Oracle: Example 1: SQL Query To find 2nd Highest and 2nd Lowest Salary using Sub-query: Step1: Create Table “Employee” as below: CREATE TABLE EMPLOYEE (   EMPNAME  VARCHAR2 (100 BYTE),   SALARY   NUMBER ); Step 2: Insert few

[Read More]
Oct 202014
 

Example 1: For Sending Email to single recipient from Oracle database follow following steps: Step 1: Compile below “Send_Mail” Procedure. CREATE OR REPLACE PROCEDURE send_mail (p_to  IN VARCHAR2, p_from     IN VARCHAR2, p_subject   IN VARCHAR2, p_html_msg IN VARCHAR2 DEFAULT NULL,  p_smtp_host IN VARCHAR2, p_smtp_port IN NUMBER DEFAULT 25) AS l_mail_conn   UTL_SMTP.connection; l_boundary   VARCHAR2(50) := ‘—-=*#abc1234321cba#*=’; BEGIN

[Read More]
Oct 162014
 
Infosys Recruitment Reviews

Through my previous post “Infosys Interview Process” I have noticed that many candidates have concerns related to salary, Location and Joining Date offered by Infosys. In this post I will share my personal experience and experiences shared by the candidates on these concerns. Salary offered by Infosys Many candidates believe that MNC’s offer hike in

[Read More]
Oct 152014
 

Oracle Forms Object Group Object Group is used to package related Form Builder objects so that they can be copied or used in another module. For Example: You might build an appointment scheduler in a form and then decide to make it available from other forms in your applications. The scheduler would probably be built

[Read More]
Oct 142014
 

In many scenarios’ you required to convert Delimited (comma or pipelined) separated row values into column in SQL. Follow following two examples step by step to convert Comma and Pipeline separated row values into column data. Example 1: Convert Comma Separated row value into column in Oracle Step 1: Create test table “Table1” with column “Col1” as

[Read More]
Oct 112014
 

SQL Query to Calculate Tenure Period from Date of Joining as following: Employees with tenure of less than 30 days should be shown as “0 to 30 days”. Employees with tenure in between 31-60 days should be shown as “31 to 60 days”. Employees with tenure in between 61-90 days should be shown as “61

[Read More]