Канал: Kishan Mashru

Fact table and Dimension table | Data Warehousing

Fact table and Dimension table | Data Warehousing

How to extract table data into csv file using python

How to extract table data into csv file using python

Python | How to Install python packages

Python | How to Install python packages

How to execute Oracle Function from Python Script | Python programming |

How to execute Oracle Function from Python Script | Python programming |

Python programming | How to execute Oracle Procedure from Python Script

Python programming | How to execute Oracle Procedure from Python Script

Python programming | Executing SQL queries with Bind Variables from python script

Python programming | Executing SQL queries with Bind Variables from python script

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

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

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

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

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

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

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

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

Python programming | Insert data into database table using python

Python programming | Insert data into database table using python

Python Programming | Connect to an Oracle database from python

Python Programming | Connect to an Oracle database from python

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

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

Centralized Version Control System (CVCs) and Distributed Version Control System (DVCs)

Centralized Version Control System (CVCs) and Distributed Version Control System (DVCs)

What is Version Control System?

What is Version Control System?

Oracle SQL and PL/SQL App by Kishan Mashru

Oracle SQL and PL/SQL App by Kishan Mashru

Oracle SQL Loader - How to load data from file(.csv, .dat, .txt) into table - Tutorial - 3

Oracle SQL Loader - How to load data from file(.csv, .dat, .txt) into table - Tutorial - 3

Oracle SQL Loader - Control File Example - Tutorial -2

Oracle SQL Loader - Control File Example - Tutorial -2

Oracle SQL Loader - Introduction - Tutorial -1

Oracle SQL Loader - Introduction - Tutorial -1

Debugging Oracle PL/SQL code with ORACLE SQL DEVELOPER tool

Debugging Oracle PL/SQL code with ORACLE SQL DEVELOPER tool

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

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

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

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

Difference between view and materialized view

Difference between view and materialized view

ORACLE PL/SQL INTERVIEW QUESTION : FACTORIAL PROGRAM

ORACLE PL/SQL INTERVIEW QUESTION : FACTORIAL PROGRAM

ORACLE PL/SQL INTERVIEW :PALINDROME NUMBER PROGRAM

ORACLE PL/SQL INTERVIEW :PALINDROME NUMBER PROGRAM

Oracle plsql Interview Question | How to reverse a number?

Oracle plsql Interview Question | How to reverse a number?

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

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

WHAT IS THE DIFFERENCE BETWEEN ROWID AND ROWNUM?? ORACLE SQL

WHAT IS THE DIFFERENCE BETWEEN ROWID AND ROWNUM?? ORACLE SQL

Query returning no records solved!!!

Query returning no records solved!!!

ORACLE SQL AND PL/SQL INTERVIEW QUESTION : SUBQUERY WITH IN / EXISTS OR SELF JOIN

ORACLE SQL AND PL/SQL INTERVIEW QUESTION : SUBQUERY WITH IN / EXISTS OR SELF JOIN

ORACLE SQL AND PL/SQL INTERVIEW QUESTION : PRINT 1 TO 5 USING SQL

ORACLE SQL AND PL/SQL INTERVIEW QUESTION : PRINT 1 TO 5 USING SQL

Oracle sql Interview Question : How to change rows to column

Oracle sql Interview Question : How to change rows to column

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

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

DIFFERENCE BETWEEN DELETE AND TRUNCATE | ORACLE SQL INTERVIEW QUESTION

DIFFERENCE BETWEEN DELETE AND TRUNCATE | ORACLE SQL INTERVIEW QUESTION

REF CURSOR AND SYS_REFCURSOR IN ORACLE PL/SQL WITH EXAMPLE

REF CURSOR AND SYS_REFCURSOR IN ORACLE PL/SQL WITH EXAMPLE

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

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

WHAT IS FOREIGN KEY IN DATABASE TABLE?

WHAT IS FOREIGN KEY IN DATABASE TABLE?

DIFFERENCE BETWEEN PRIMARY KEY AND UNIQUE KEY CONSTRAINT IN ORACLE SQL

DIFFERENCE BETWEEN PRIMARY KEY AND UNIQUE KEY CONSTRAINT IN ORACLE SQL

All you need to know about PRIMARY KEY of a database table

All you need to know about PRIMARY KEY of a database table

WHAT IS UNIQUE KEY CONSTRAINT IN ORACLE SQL?

WHAT IS UNIQUE KEY CONSTRAINT IN ORACLE SQL?

NOT NULL AND CHECK CONSTRAINT IN ORACLE SQL WITH EXAMPLE

NOT NULL AND CHECK CONSTRAINT IN ORACLE SQL WITH EXAMPLE

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

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

DYNAMIC SQL WITH EXECUTE IMMEDIATE IN ORACLE PL/SQL WITH EXAMPLE

DYNAMIC SQL WITH EXECUTE IMMEDIATE IN ORACLE PL/SQL WITH EXAMPLE

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

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

ADVANCE CREATE TABLE STATEMENT IN SQL

ADVANCE CREATE TABLE STATEMENT IN SQL

TYPES OF SQL STATEMENTS

TYPES OF SQL STATEMENTS

GLOBAL TEMPORARY TABLE (GTT) IN ORACLE SQL WITH EXAMPLES

GLOBAL TEMPORARY TABLE (GTT) IN ORACLE SQL WITH EXAMPLES

WHAT ARE VIEWS IN DATABASE??

WHAT ARE VIEWS IN DATABASE??

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

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

LNNVL FUNCTION IN ORACLE SQL

LNNVL FUNCTION IN ORACLE SQL

COALESCE IN ORACLE SQL

COALESCE IN ORACLE SQL

NULLIF FUNCTION IN ORACLE SQL WITH EXAMPLE

NULLIF FUNCTION IN ORACLE SQL WITH EXAMPLE

NVL2 FUNCTION IN ORACLE SQL WITH EXAMPLE

NVL2 FUNCTION IN ORACLE SQL WITH EXAMPLE

HOW TO REPLACE NULL VALUE IN ORACLE SQL?

HOW TO REPLACE NULL VALUE IN ORACLE SQL?

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

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

HOW TO RETURN MULTIPLE VALUES FROM A PROCEDURE IN ORACLE PL/SQL? (USING OUT PARAMETERS)

HOW TO RETURN MULTIPLE VALUES FROM A PROCEDURE IN ORACLE PL/SQL? (USING OUT PARAMETERS)

Difference between Case and Decode

Difference between Case and Decode

DECODE FUNCTION IN ORACLE SQL

DECODE FUNCTION IN ORACLE SQL

CASE STATEMENT(IF THEN ELSE) IN ORACLE SQL WITH EXAMPLE

CASE STATEMENT(IF THEN ELSE) IN ORACLE SQL WITH EXAMPLE

ORDER BY WITH MULTIPLE COLUMNS

ORDER BY WITH MULTIPLE COLUMNS

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

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

DIFFERENT WAYS TO CALL / EXECUTE A PROCEDURE IN ORACLE PL/SQL? (Position, Named and Mixed Notations)

DIFFERENT WAYS TO CALL / EXECUTE A PROCEDURE IN ORACLE PL/SQL? (Position, Named and Mixed Notations)

Procedures in Oracle PL/SQL

Procedures in Oracle PL/SQL

User defined Exception in Oracle PL/SQL

User defined Exception in Oracle PL/SQL

Exception handling in oracle pl/sql with example

Exception handling in oracle pl/sql with example

WHAT IS SQLCODE AND SQLERRM IN ORACLE PL/SQL

WHAT IS SQLCODE AND SQLERRM IN ORACLE PL/SQL

DYNAMIC SQL WITH EXECUTE IMMEDIATE IN ORACLE PL/SQL

DYNAMIC SQL WITH EXECUTE IMMEDIATE IN ORACLE PL/SQL

Materialized Views in Oracle (Part - 2 Practical Implementation with Examples)

Materialized Views in Oracle (Part - 2 Practical Implementation with Examples)

Materialized Views in Oracle ( Part - 1 Introduction)

Materialized Views in Oracle ( Part - 1 Introduction)

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

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

Wrapping Oracle PL/SQL code

Wrapping Oracle PL/SQL code

UNION AND UNION ALL SET OPERATOR IN ORACLE SQL

UNION AND UNION ALL SET OPERATOR IN ORACLE SQL

DIFFERENCE BETWEEN CHAR AND VARCHAR2 DATATYPE IN ORACLE SQL

DIFFERENCE BETWEEN CHAR AND VARCHAR2 DATATYPE IN ORACLE SQL

Merge Statement in Oracle SQL with Example (UPDATE/DELETE or INSERT)

Merge Statement in Oracle SQL with Example (UPDATE/DELETE or INSERT)

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

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

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

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

CARTESIAN PRODUCT OR CROSS JOIN IN ORACLE SQL WITH EXAMPLE

CARTESIAN PRODUCT OR CROSS JOIN IN ORACLE SQL WITH EXAMPLE

INNER JOIN OR SIMPLE JOIN IN ORACLE SQL WITH EXAMPLE

INNER JOIN OR SIMPLE JOIN IN ORACLE SQL WITH EXAMPLE

Row Number Vs Rank Vs Dense Rank

Row Number Vs Rank Vs Dense Rank

Difference between Replace and Translate function in oracle

Difference between Replace and Translate function in oracle

ORACLE SQL AND PL/SQL INTERVIEW QUESTION : HOW TO CHANGE DATATYPE IN ORACLE SQL?

ORACLE SQL AND PL/SQL INTERVIEW QUESTION : HOW TO CHANGE DATATYPE IN ORACLE SQL?

HOW TO IDENTIFY AND DELETE DUPLICATE ROWS USING ROWID AND GROUPBY IN ORACLE SQL

HOW TO IDENTIFY AND DELETE DUPLICATE ROWS USING ROWID AND GROUPBY IN ORACLE SQL

Difference between Procedure and Function

Difference between Procedure and Function

How to commit in a trigger?

How to commit in a trigger?

What is PRAGMA AUTONOMOUS_TRANSACTION in oracle?

What is PRAGMA AUTONOMOUS_TRANSACTION in oracle?

What is High Water Mark(HVM) in oracle and how it effects the performance of queries?

What is High Water Mark(HVM) in oracle and how it effects the performance of queries?

How to recover a dropped table in oracle?

How to recover a dropped table in oracle?

Difference between Delete and Truncate and Drop in Oracle Sql

Difference between Delete and Truncate and Drop in Oracle Sql

Cursors in Oracle PL/SQL | Oracle PLSQL concepts

Cursors in Oracle PL/SQL | Oracle PLSQL concepts

UPDATE STATEMENT WITH JOIN IN ORACLE SQL

UPDATE STATEMENT WITH JOIN IN ORACLE SQL

how to unlock oracle user account? ORA-28000: the account is locked

how to unlock oracle user account? ORA-28000: the account is locked

Find the Second highest salary

Find the Second highest salary

IN v/s EXISTS v/s JOIN, which one will give better performance under what condition?

IN v/s EXISTS v/s JOIN, which one will give better performance under what condition?

How to solve ORA-28000: the account is locked

How to solve ORA-28000: the account is locked

How to Join two tables in a update statement

How to Join two tables in a update statement

Interview Question | How to find 2nd max salary in a table using analytical functions in oracle

Interview Question | How to find 2nd max salary in a table using analytical functions in oracle

IN VS EXISTS VS JOIN, performance

IN VS EXISTS VS JOIN, performance