SQL/PLSQL ALL POSTS

 SQL/PLSQL ALL POSTS

SQL INTRODUCTION

ORA-01732: data manipulation operation not legal on this view

Oracle PL/SQL Important Topics

ROLLUP, CUBE, GROUPING Functions and GROUPING SETS

Oracle PL/SQL: Coalesce Function

SQL Trace and TKPROF

SQL Trace and TKPROF

External tables

Using UTL_FILE In Oracle

SQL Tuning \

Bulk Collect And Forall in Oracle

Sub programs in PLSQL

Oracle Cursor Basics

Advance Pl/sql

Triggers

SQL QUERIE

Subqueries

Lexical Parameters Interview Questions

Constraints

Operators

NUMBER AND CHARACTER FUNCTIONS

VIEWS AND SEQUENCES

Functions,procedures,packages

EXCEPTIONS

cursor

PLSQL: Procedural Structured Query Language

PRAGMA AUTONOMOUS_TRANSACTION

How to work with Date Functions?? How to add days in current date?

DCL Data control Language , TCL -Transaction Control Language

collections

PLSQL Interview questions

SQL -- Structured Query Language

PLSQL important Question and Answers

PLSQL: Identify special characters in the string

Difference Between NVL and NVL2

Difference between Case and Decode

The below are somewritng a query with the select clause where we can Select some columns or all columns from the table… examples of

Oracle SQL :Normalization

PLSQL Collections

How to use Case and DECODE function???

Oracle APPS Releated Queries AD Patch tables ,FND Tables 

Patch Queries Fnd Queries ,Script for Patch Log Analysis :

How to work with Date Functions??

Procedure and function Syntax and Example

Procedure and function Syntax and Example

Bulk Binds (BULK COLLECT & FORALL) and Record Processing in Oracle

To get the time of the particular ,To get the Current time of the DB

Invoking SQL*Loader 1

Invoking SQL*Loader

PL/SQL: Stop Making the Same Performance Mistakes

SQL*Loader and external Tables

SQL Functions

RANK, DENSE_RANK, FIRST and LAST Analytic Functions

PRAGMA AUTONOMOUS_TRANSACTION