Oracle SQL & PL/SQL

SQL, SQL Server, Tutorials, Oracle, PL/SQL, Interview Questions & Answers, Joins, Multiple Choice Questions, Quiz, Stored Procedures, Select, Insert, Update, Delete and other latest topics on SQL, SQL Server and Oracle.

Oracle Good Books

Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions by Thomas Kyte

Oracle Database 10g PL/SQL Programming by Scott Urman, Ron Hardman, and Michael McLaughlin

Oracle Discoverer 10g Handbook (Oracle) by Darlene Armstrong-Smith and Michael Armstrong-Smith

Oracle Database 10g RMAN Backup & Recovery by Matthew Hart and Robert G. Freeman

Cost-Based Oracle Fundamentals by Jonathan Lewis

Oracle Database 10g SQL (Osborne ORACLE Press Series) by Jason Price and McGraw-Hill

Oracle Database 10g Real Application Clusters Handbook (Osborne Oracle Press) by K Gopalakrishnan

Oracle PL/SQL Programming, 4th Edition by Steven Feuerstein and Bill Pribyl

Effective Oracle Database 10g Security by Design by David Knox and McGraw-Hill

Effective Oracle by Design (Osborne ORACLE Press Series) by Thomas Kyte

Oracle Database 10g Insider Solutions by Arun Kumar, John Kanagaraj, and Richard Stroupe

Oracle 10g RAC Grid, Services & Clustering by Murali Vallath

Optimizing Oracle Performance by Cary Millsap and Jeff Holt

Mastering Oracle SQL, 2nd Edition by Sanjay Mishra and Alan Beaulieu

Oracle SQL by Example, Third Edition by Alice Rischert

No comments:

Post a Comment

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)

SQL Server - Multiple Choice Questions

SQL - Multiple Choice Questions

SQL Server, Oracle, SQL & PL/SQL

If you like reading this SQL Server, Oracle, SQL / PLSQL blog, please help increase the blogs' visibility by clicking on the 'g +1' button.

SQL Server / Oracle SQL

sql introduction

SQL Introduction

SQL Syntax

SQL Select

SQL Insert

SQL Update

SQL Delete

SQL Joins

Examples of Joins

SQL Examples of Joins

Explicit vs. Implicit Joins

SQL Explicit vs. Implicit Joins

SQL Group By

SQL Group By Examples

SQL Group By Examples

SQL Having

SQL - IN

SQL - NULLs

Functional Dependencies

Functional Dependencies

Normalization

ACID Properties

ACID Properties

SQL SubQueries

SQL - Queries With Examples

SQL - Queries With Examples

SQL Views

Insert, Update, Delete Views

Insert, Update, Delete Views

SQL Join Views

SQL Inline Views

Nth Highest Salary

SQL - Nth Highest Salary

Second Highest Salary

SQL Second Highest Salary

Difference Truncate / Delete

SQL - Difference Truncate / Delete

Difference Truncate / Drop

SQL - Difference Truncate / Drop

Difference HAVING / WHERE

SQL - Difference HAVING / WHERE

Difference CAST / CONVERT

SQL - Difference CAST / CONVERT

Difference NOT IN / NOT EXIST

SQL - Difference NOT IN / NOT EXIST

SQL - Difference IN / EXISTS

SQL - Difference IN / EXISTS

Difference UNION / UNION ALL

SQL - Difference UNION / UNION ALL

Difference Nested / Correlated Subquery

SQL - Difference Nested / Correlated Subquery

SQL - REPLACE

SQL - TOP

SQL - LIKE

SQL - SELECT INTO

SQL - SELECT INTO

SQL - CREATE TABLE

SQL - CREATE TABLE

SQL - CREATE TABLE

SQL - CREATE TABLE (More Examples)

SQL - ALTER TABLE

SQL - ALTER TABLE

Difference views / Materialized views

SQL - Difference views / Materialized views

SQL Count

SQL Update

SQL Clustered / Non-Clustered Indexes

SQL Clustered / Non-Clustered Indexes

SQL - Delete Duplicate Records

SQL - Delete Duplicate Records

SQL - Difference Unique/Primary Key

SQL - Difference Unique/Primary Key

SQL - GETDATE()

SQL - DATEDIFF()

SQL - DATEADD()

SQL - DATEPART()

SQL - Convert()

SQL - Convert()

SQL - SUM()

SQL - AVG()

SQL - MIN()

SQL - MAX()

SQL - Insert Into Select

SQL - Insert Into Select

Insert Multiple Values In Table

SQL - Insert Multiple Values In Table

Referential Integrity

SQL - Referential Integrity

Not Null Constraint

SQL - Not Null Constraint

SQL - Unique Constraint

SQL - Unique Constraint

Primary Key Constraint

SQL - Primary Key Constraint

Foreign Key Constraint

SQL - Foreign Key Constraint

Default Constraint

SQL - Default Constraint

Check Constraint

SQL - Check Constraint

SQL - ROLLUP

SQL - CUBE

SQL - STUFF()

SQL - Count_Big

SQL - Count_Big

SQL - Binary_Checksum

SQL - Binary_Checksum

SQL - Checksum_AGG

SQL - Checksum_AGG

SQL - Index Include

SQL - Index Include

SQL - Covered Query

SQL - Covered Query

SQL - Identity

SQL - sp_columns

SQL - sp_columns

Difference Local / Global Temporary Tables

SQL - Diff Local/Global Temporary Tables

Stored Procedure

SQL - Stored Procedure

SQL - sp_who

SQL - Session

SQL - Dynamic SQL

SQL Server Execution Plan

SQL - SQL Server Execution Plan

SQL - sp_executesql

Difference Execute/Execute()

SQL - Difference Execute/Execute()

SQL - Case Expression

SQL - Case Expression

SQL - XML Variable Example

SQL - XML Variable Example

SQL - Pivot

Example of SQL Merge

Example of SQL Merge

Example of Merge Output Clause

Example of Merge Output Clause

SQL - Compute / Compute by

SQL - Compute / Compute by

SCOPE_IDENTITY / IDENT_CURRENT / @@IDENTITY

SQL - Diff SCOPE_IDENTITY / IDENT_CURRENT / @@IDENTITY

SQL Coalesce

Import Data into SQL Server Table

SQL - Import Data into SQL Server Table

Delete Duplicate Records in SQL Server Table

SQL - Delete Duplicate Records in SQL Server Table

Check If a Column Exists in SQL Server Table

SQL - Check If a Column Exists in SQL Server Table

Has_perms_by_name

SQL - Has_perms_by_name

SQL - Difference between Logins / Users

SQL - Difference between Logins / Users

Diff between Table Variable/Temp Table

SQL - Diff between Table Variable/Temp Table

SQLServer 2012 features

SQL - SQLServer 2012 features

SQL - SERVERPROPERTY

SQL - SERVERPROPERTY

Find Primary Key / Foreign Key in Table

SQL - Find Primary Key / Foreign Key in Table

SQL - Sequence

Columnstore Indexes

SQL - Columnstore Indexes

Difference Primary / Candidate Key

SQL - Difference Primary / Candidate Key

SQL - Throw - SQL Server 2012

SQL - Throw - SQL Server 2012

Difference GUID / INT

SQL - Difference GUID / INT

SQL Server 2012 Enhancements

SQL Server 2012 Enhancements

Difference between Cross Join / Full Outer Join

SQL - Diff between Cross Join / Full Outer Join

SQL - NTILE()

SQL - Object Dependencies

SQL - Object Dependencies

SQL - Email Reminder on Updating Table

SQL - Email Reminder on Updating Table

SQL - Object Definition

SQL - Object Definition

SQL Server - Report Builder 3

SQL Server - Report Builder 3

SQL Server - User Defined Roles

SQL Server - User Defined Roles

SQL Server - Filetables

SQL Server - Filetables

SQL Server - Contained Databases

SQL Server - Contained Databases

Update from Select

SQL Server - Update from Select

SQL Server - XML Methods

SQL Server - XML Methods

Add a Column to Table

SQL Server - Add a Column to Table

SQL Insert Multiple Rows

SQL Server - Insert Multiple Rows

Add Identity Column to Table

SQL Server - Add Identity Column to Table

SQL Server - Indexes

SQL Server - Indexes

Difference Functions / Stored Procedures

SQL Server - Diff Functions / Stored Procedures

SQL - Comparison Operators Any / All

SQL - Comparison Operators Any / All

Difference Primary / Foreign Key

SQL - Difference Primary / Foreign Key

Difference Replace / Stuff

SQL - Difference Replace / Stuff

SQL - ROW_NUMBER()

SQL - ROW_NUMBER()

SQL - Intersect

SQL - Intersect

SQL Server - Local Variables

SQL Server - Local Variables

Update with Join

SQL Server - Update with Join

Difference Merge / Hash Join

SQL Server - Difference Merge / Hash Join

Difference Update / Exclusive Lock

SQL Server - Difference Update / Exclusive Lock

sql Difference Instance / Database

SQL Server - Difference Instance / Database

Difference Datetime2 / Datetime

SQL Server - Difference Datetime2 / Datetime

Difference Disable / Drop Indexes

SQL Server - Difference Disable / Drop Indexes

SQL Server - Difference Decimal / Float

SQL Server - Difference Decimal / Float

DATEDIFF with Examples

SQL Server - DATEDIFF with Examples

sql Difference Raiserror / Throw

SQL Server - Difference Raiserror / Throw

Check If Column Exists in Table

SQL Server - Check If Column Exists in Table

Query Excel Using Linked Server

SQL Server - Query Excel Using Linked Server

SQL Server - WaitFor

SQL Server - WaitFor

Difference Rank, Dense_Rank & Row_Number

SQL Server - Difference Rank, Dense_Rank & Row_Number

PATINDEX Examples

SQL Server - PATINDEX Examples

COLLATE Examples

SQL Server - COLLATE Examples

Difference CHAR / VARCHAR

SQL Server - Difference CHAR / VARCHAR

SQL Interview Questions

SQL Server - Interview Questions for Testers

SQL Interview Questions

SQL Interview Questions

Difference GRANT / DENY / REVOKE

Difference GRANT / DENY / REVOKE

Subqueries in WHERE clause - Examples

Subqueries in WHERE clause - Examples

How to check indexes on a table?

How to check indexes on a table?

DATENAME examples

DATENAME examples

SQL Join Interview Questions

SQL Join Interview Questions

Oracle PL/SQL

PL/SQL Introduction

PL/SQL Introduction

PL/SQL Procedures

PL/SQL Procedures

PL/SQL Functions

PL/SQL Functions

PL/SQL Collections

PL/SQL Collections

PL/SQL Records

PL/SQL Table Based Records

PL/SQL Table Based Records

PL/SQL Programmer Defined Records

PL/SQL Programmer Defined Records

PL/SQL Cursor Based Records

PL/SQL Cursor Based Records

PL/SQL Tables

PL/SQL Varrays

PL/SQL Nested Tables

PL/SQL Nested Tables

PL/SQL Loops

PL/SQL Triggers

PL/SQL Triggers

PL/SQL Cursors

PL/SQL Implicit Cursors

PL/SQL Implicit Cursors

PL/SQL Explicit Cursors

PL/SQL Explicit Cursors

PL/SQL REF Cursors

PL/SQL REF Cursors

PL/SQL Cursor For Loop

PL/SQL Cursor For Loop

PL/SQL Cursors with Parameters

PL/SQL Cursors with Parameters

PL/SQL Where Current Of and For Update

PL/SQL Where Current Of and For Update

Examples of PL/SQL Cursors

Examples of PL/SQL Cursors

PL/SQL Exceptions

PL/SQL Exceptions

PL/SQL Interview Questions

PL/SQL Interview Questions

SQL PL/SQL Sitemap

SQL PL/SQL Sitemap

SQL Tutorials / Topics

always encrypted Best Practices for Creating Indexes case expression in sql case statement in select query in sql char char and varchar examples check indexes on table oracle check indexes on table sql server Collate Collate Examples Common Table Expressions Contained Databases DATEDIFF DateDiff Examples DATEDIFF Oracle DATENAME DATENAME Examples datename function in sql DATETIME DATETIME2 Dense_Rank Dense_Rank & Row_Number DENY & REVOKE difference between coalesce and isnull with example difference between coalesce() & isnull() Difference between DATETIME2 / DATETIME Difference between EXISTS and IN in SQL Difference between GRANT Difference between Grant and Revoke Difference between isNull & COALESCE Difference between Merge Join and Hash Join difference between merge join and hash join in sql server Difference Between Rank difference char and varchar difference char and varchar in sql difference char varchar Difference decimal / float Difference Disable and Drop Indexes Difference RAISERROR and THROW Difference Server Instance / Database Drop Indexes Dynamic Data Masking exist sql exists sql oracle exists sql vs in find indexes on table Hash Join hash join example hash join in dbms hash join in oracle hash join in sql hash join vs merge join how to use datename in sql how to use index in sql server indexes on table indexes on temp tables indexes on views isnull and coalesce difference Join Hints join hints in sql server join hints oracle JOIN Interview Questions joins joins in sql JOINS Interview Questions know indexes on a table Merge Join merge join example merge join in dbms merge join in sql merge join in sql server Multiple Choice mysql join hints NULLIF ORACLE NULLIF oracle sql case expression oracle sql joins ORACLE SQL NULLIF Partially Contained Databases PATINDEX examples Query to check index on a table Rank revoke vs deny : what is the difference Row_Number self join self join examples self join questions self join sql sparse columns sparse columns in sql server SQL sql always encrypted sql always encrypted c# sql always encrypted connection string sql case expression sql case expression in where clause SQL Columnstore Indexes SQL Data Types SQL DateDiff SQL DATENAME SQL decimal / float difference SQL Delete sql deny vs revoke SQL Excel Linked Server SQL EXISTS & IN SQL Expressions SQL GRANT sql grant and revoke SQL HAVING / GROUP BY SQL Identity Column Questions SQL Inbuilt Functions SQL Indexes SQL Insert SQL Insert and Update SQL Interview Questions SQL JOIN Interview Questions SQL Join Questions SQL Join Questions & Answers sql joins SQL Joins & Nulls sql joins interview questions sql joins practice sql joins practice questions sql joins questions sql joins with examples SQL Keys SQL Local Variables SQL Merge SQL Normalization SQL NULL SQL NULLIF SQL ORDER BY SQL PL/SQL Interview Questions sql self join SQL Server - WAITFOR SQL Server 'Like' SQL Server Backup & Restore SQL Server Cast & Convert SQL Server Collate SQL Server Collation Examples SQL Server Contained Databases SQL Server Date / Time SQL Server DateDiff SQL Server DATENAME() Function SQL Server Exclusive Lock SQL Server Files & Filegroups SQL Server Inbuilt Functions sql server index creation best practices SQL Server Indexed Views SQL Server Indexes SQL Server Indexes best practices SQL Server Interview SQL Server Interview Questions SQL Server Linked Server SQL Server Locks SQL Server Permissions SQL Server Questions SQL Server Questions Answers SQL Server Row Level Security SQL Server Sequence Objects SQL Server sparse columns SQL Server Table Columns SQL Server Update Lock SQL Server Window Functions SQL sparse columns SQL Stored Procedures Questions Answers SQL Subqueries SQL Subquery SQL Tables SQL Temp Tables SQL Truncate SQL Union sql update with join SQL Views SQL Where Clause SQL Where with Wildcards SQL XML Data Type & Columns subqueries subqueries examples subqueries in where Subqueries in WHERE Clause subquery subquery in sql types of subqueries in sql union all union all example union all in oracle union all in sql union all vs union update with join in oracle update with join in sql update with join in sql server varchar Why & When should I use SPARSE COLUMN

Powered by Blogger.