Please Visit Our New Website for Further Communication

SQL Tips and Tricks

SQL Programming

Amazon

No posts with label SQL Queries. Show all posts

No posts with label SQL Queries. Show all posts

Subscribe to: Posts (Atom)

Random Posts

Amazon

Search This Blog

Useful Url's

Java Technology Blog
SQL Server Blog

Translate

Categories

D2K (7)
General Questions (1)
Indexes (1)
Interview Questions (8)
Interviews (2)
OCP Certification (1)
Oracle (8)
Oracle Forms (4)
Oracle Reports (3)
Performance Tuning (1)
PL/SQL (2)
SQL Queries (7)

Blog Archive

▼ 2013 (21)
- ▼ April (4)
- ► March (7)
- ► February (5)
- ► January (5)

Popular Posts

Page Break vs Page Protect

Page Break Before: The Page Break Before property indicates that you want the object to be formatted on the page after the page on wh...
Oracle PL/SQL Interview Questions

What is difference between SQL and PL/SQL? Difference between Truncate and Delete commands. What is a Merge command? Difference between...
To Compare “NULL” Values Use “NVL” Function in Oracle

Query to compare “Null” values in oracle tables: Step1: Create a Table “Test1” as shown below: CREATE TABLE TEST1 (A NUMBER,B NUMBER);...
SQL Query to Fetch Even/Odd values in Oracle

To fetch Even/Odd values from a numeric column in an Oracle Table: Step 1: Create a Table “Test” as shown below: CREATE TABLE TEST (...
INFOSYS Interview Process for Experienced Professionals

Aspiring candidate’s can apply for Infosys recruitment by directly login to Infosys careers website: http://www.infosys.com/careers/appl...
Compute, Validate and Rebuild Indexes in Oracle

Step 1: Save the below script in some particular location (suppose the path is D:\Exec_Indexing.sql) with extension .Sql spool d:\Indexi...
System Variables

System Variables: System variables are oracle form variables that is used to control the way an application behaves. List of system ...
SQL Query to Fetch Order-wise Month from Date Column in Oracle

Query to fetch order-wise “Month” from Date column in an Oracle Table: Step 1: Create a Table “Test” as shown below: CREATE TABLE TE...
To Find Missing Values from Set of Values in Oracle

Query to fetch missing numeric values from given set of values in oracle table: Step 1: Create a Table “TEMP” as shown below: CREATE ...
Lexical Parameter

Lexical Parameters: Lexical Parameters performs dynamic SQL query. Use to change the data definition at runtime. Use Lexical referen...

OURITBLOG

Unknown

View my complete profile

Amazon

Shop Amazon - Sell Us Your Books - Get up to 80% Back

© 2013-2014 Neeraj Gupta. Awesome Inc. theme. Powered by Blogger.