DEV Community

Pranav Bakare profile picture

Pranav Bakare

Oracle Full Stack Developer

Work

System Engineer at TCS

Inline View Method and the Correlated Subquery in SQL

Inline View Method and the Correlated Subquery in SQL

Comments
3 min read

Want to connect with Pranav Bakare?

Create an account to connect with Pranav Bakare. You can also sign in below to proceed if you already have an account.

Already have an account? Sign in
Calculate the highest salary in each department in SQL

Calculate the highest salary in each department in SQL

1
Comments
4 min read
BULK COLLECT | FORALL | SELECT INTO | FETCH & LIMIT |

BULK COLLECT | FORALL | SELECT INTO | FETCH & LIMIT |

Comments
3 min read
Query Optimization in PL/SQL

Query Optimization in PL/SQL

1
Comments
4 min read
PL/SQL developer interview perspective 10 Sections

PL/SQL developer interview perspective 10 Sections

Comments
2 min read
VARRAY (Variable-size array) - Collection in PLSQL

VARRAY (Variable-size array) - Collection in PLSQL

Comments
3 min read
View with Join Condition in SQL

View with Join Condition in SQL

Comments
2 min read
Exception handling in PLSQL | Predefined and User Defined

Exception handling in PLSQL | Predefined and User Defined

Comments
2 min read
Exception Handling in PL/SQL| RAISE_APPLICATION_ERROR | Part 2

Exception Handling in PL/SQL| RAISE_APPLICATION_ERROR | Part 2

9
Comments
2 min read
Exceptional Handling in PLSQL | Main Part

Exceptional Handling in PLSQL | Main Part

5
Comments
4 min read
Exception Handling in PL/SQL| PRAGMA EXCEPTION_INIT | Part 3

Exception Handling in PL/SQL| PRAGMA EXCEPTION_INIT | Part 3

9
Comments
2 min read
Exception handling in PLSQL | EXCEPTION keyword | PART 1

Exception handling in PLSQL | EXCEPTION keyword | PART 1

10
Comments
2 min read
Constraint in SQL

Constraint in SQL

1
Comments
3 min read
Keys in SQL | Primary Key | Foreign Key| Candidate Key|Composite Key |Alternate Key|Super Key|Surrogate Key| Unique Key

Keys in SQL | Primary Key | Foreign Key| Candidate Key|Composite Key |Alternate Key|Super Key|Surrogate Key| Unique Key

Comments
3 min read
Normalisation in SQL

Normalisation in SQL

10
Comments 1
3 min read
du vs df commands in linux

du vs df commands in linux

Comments 1
2 min read
Top 10 networking commands

Top 10 networking commands

Comments
2 min read
Named Calling Notations in PLSQL

Named Calling Notations in PLSQL

Comments
2 min read
Stored procedure in PLSQL

Stored procedure in PLSQL

Comments
3 min read
Materialized view in PLSQL

Materialized view in PLSQL

Comments
1 min read
PACKAGES in PLSQL in detail

PACKAGES in PLSQL in detail

Comments
4 min read
Row-level triggers (FOR EACH ROW) And Statement-level triggers

Row-level triggers (FOR EACH ROW) And Statement-level triggers

Comments
7 min read
MERGE in SQL

MERGE in SQL

Comments
2 min read
LEAD vs LAG Function in SQL

LEAD vs LAG Function in SQL

Comments
2 min read
Data | Information | Knowledge| Insights | Wisdom

Data | Information | Knowledge| Insights | Wisdom

Comments
2 min read
Advanced SQL and PL/SQL concept

Advanced SQL and PL/SQL concept

Comments
3 min read
Indexes in SQL - Clustered Index and Non-Clustered Index

Indexes in SQL - Clustered Index and Non-Clustered Index

9
Comments 1
2 min read
Lookup tables in SQL

Lookup tables in SQL

Comments
2 min read
CTE

CTE

Comments
2 min read
Virtual tables in SQL - Views, Materialized View, Global Temporary Table and Inline View

Virtual tables in SQL - Views, Materialized View, Global Temporary Table and Inline View

Comments
2 min read
SQL Injection

SQL Injection

Comments
1 min read
Indexing in SQL

Indexing in SQL

Comments
2 min read
Views and Materialized View in SQL

Views and Materialized View in SQL

Comments
3 min read
PLSQL DEV

PLSQL DEV

5
Comments
2 min read
Git Merge and Git Rebase

Git Merge and Git Rebase

Comments 1
3 min read
Git fetch and Git pull

Git fetch and Git pull

Comments
2 min read
Waterfall vs Agile in SDLC

Waterfall vs Agile in SDLC

8
Comments
1 min read
Dynamic SQL

Dynamic SQL

Comments
2 min read
EXECUTE IMMEDIATE in PL/SQL

EXECUTE IMMEDIATE in PL/SQL

8
Comments
2 min read
Formal and Actual parameters in Stored Procedure in PLSQL

Formal and Actual parameters in Stored Procedure in PLSQL

Comments
2 min read
Exception Handling in PL/SQL

Exception Handling in PL/SQL

5
Comments
3 min read
DBMS_OUTPUT.PUT_LINE in PLSQL

DBMS_OUTPUT.PUT_LINE in PLSQL

Comments
1 min read
Functions in PL/SQL

Functions in PL/SQL

4
Comments
2 min read
Procedure in PLSQL

Procedure in PLSQL

10
Comments
2 min read
Primary Key and Foreign Key in SQL | Part 1

Primary Key and Foreign Key in SQL | Part 1

4
Comments
2 min read
Primary Key and Foreign Key in SQL | Part 2

Primary Key and Foreign Key in SQL | Part 2

8
Comments
3 min read
BULK COLLECT in PL/SQL

BULK COLLECT in PL/SQL

Comments
5 min read
Difference between UNION and UNION ALL in SQL

Difference between UNION and UNION ALL in SQL

Comments
4 min read
%TYPE and %ROWTYPE Attributes in PLSQL

%TYPE and %ROWTYPE Attributes in PLSQL

Comments
2 min read
Masking in SQL | PART 2

Masking in SQL | PART 2

8
Comments 3
2 min read
Masking in SQL | PART 1

Masking in SQL | PART 1

1
Comments
2 min read
Cursor Types in PLSQL -Normal cursor and Reference cursor

Cursor Types in PLSQL -Normal cursor and Reference cursor

7
Comments
4 min read
Cursor in PLSQL - Best Explanation

Cursor in PLSQL - Best Explanation

Comments
2 min read
Data masking in PL/SQL

Data masking in PL/SQL

Comments
3 min read
BULK COLLECT in PL/SQL

BULK COLLECT in PL/SQL

Comments
2 min read
Common Table Expression (CTE) in PLSQL | Part 2

Common Table Expression (CTE) in PLSQL | Part 2

11
Comments
2 min read
Trigger in PL/SQL with Example - Part 2 | AFTER Trigger

Trigger in PL/SQL with Example - Part 2 | AFTER Trigger

9
Comments
2 min read
SQL - Sub Queries

SQL - Sub Queries

2
Comments
3 min read
Cursor in PLSQL

Cursor in PLSQL

9
Comments
3 min read
PL/SQL collections - Associative Arrays, Nested Tables & VARRAYs.

PL/SQL collections - Associative Arrays, Nested Tables & VARRAYs.

9
Comments
2 min read
loading...