Kishan Mashru

LNNVL FUNCTION IN ORACLE SQL

NVL2 FUNCTION IN ORACLE SQL WITH EXAMPLE

User defined Exception in Oracle PL/SQL

Oracle SQL Loader - Control File Example - Tutorial -2

How to get the exact error line number in Oracle PL/SQL?

ORACLE PL/SQL INTERVIEW QUESTION : FACTORIAL PROGRAM

Oracle SQL Loader - Introduction - Tutorial -1

INNER JOIN OR SIMPLE JOIN IN ORACLE SQL WITH EXAMPLE

Python programming | How to execute Oracle Procedure from Python Script

How to read data from table in python | Python programming | Part - 3

NOT NULL AND CHECK CONSTRAINT IN ORACLE SQL WITH EXAMPLE

ORACLE SQL AND PL/SQL INTERVIEW QUESTION : HOW TO DELETE DUPLICATE RECORDS FROM A TABLE ? |3 ways

NULLIF FUNCTION IN ORACLE SQL WITH EXAMPLE

Difference between Case and Decode

SOLVED!!! HOW TO CREATE COPY OF A TABLE FOR BACKUP IN DATABASE? WITH AND WITHOUT DATA

What is %type and %rowtype variable in oracle PL/SQL : Interview Question

ORACLE SQL INTERVIEW QUESTION : HOW TO SELECT ODD OR EVEN ROWS FROM A TABLE IN ORACLE

Python programming | How to insert multiple records into database table using python

Oracle sql Interview Question : How to change rows to column

WHAT IS ON DELETE CLAUSE OF FOREIGN KEY CONSTRAINT IN ORACLE SQL?? ADVANCE FOREIGN KEY CONCEPTS!!!

SEQUENCES IN ORACLE SQL WITH EXAMPLES (asc, desc, cycle, nocycle, cache, nocache)

OUTER JOIN IN ORACLE SQL WITH EXAMPLE (LEFT / RIGHT/ FULL OUTER JOIN)

Fact table and Dimension table | Data Warehousing

Database views explained

GLOBAL TEMPORARY TABLE (GTT) IN ORACLE SQL WITH EXAMPLES

ORACLE PL/SQL INTERVIEW :PALINDROME NUMBER PROGRAM

How to solve ORA-01940: cannot drop a user that is currently connected

WHAT IS FOREIGN KEY IN DATABASE TABLE?

TYPES OF SQL STATEMENTS

WHAT IS UNIQUE KEY CONSTRAINT IN ORACLE SQL?

Query returning no records solved!!!

Oracle plsql Interview Question | How to reverse a number?

Cursors in Oracle PL/SQL | Oracle PLSQL concepts

How to use Pivot and Unpivot? (how to change rows to column and column to rows)

What is Version Control System?

How to solve ORA-28002: the password will expire warning

DIFFERENCE BETWEEN PROCEDURE AND FUNCTION IN ORACLE PL/SQL WITH EXAMPLE

LNNVL FUNCTION IN ORACLE SQL | Check NULL value in SQL statement

PRINT 1 TO 5 USING SQL | Hierarchical query in sql | ORACLE SQL AND PL/SQL INTERVIEW QUESTION

rowid and rownumber in sql | oracle | Difference between rowid and row_number

UNION AND UNION ALL SET OPERATOR IN ORACLE SQL

FUNCTIONS IN ORACLE PL/SQL (basic to advance examples)

Difference between view and materialized view

REF CURSOR AND SYS_REFCURSOR IN ORACLE PL/SQL WITH EXAMPLE

CHANGE DATATYPE IN SQL | change datatype of column | ORACLE SQL AND PL/SQL INTERVIEW QUESTION

Python programming | Insert data into database table using python

How to return multiple values from a function in oracle pl/sql ? (without using out parameter)

Debugging Oracle PL/SQL code with ORACLE SQL DEVELOPER tool

IN v/s EXISTS v/s JOIN, performance tuning | Interview question

Python programming | Select or get data from table using python | Extract data from table | Part - 2

Materialized Views in Oracle ( Part - 1 Introduction)