Saturday, January 15, 2022

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

No comments:

Post a Comment

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...