Skip to content
  • Home
  • About Us
  • Privacy Policy
  • Contact Us

SQL WORLD

Parse, Bind, Optimize, Execute
SQL WORLD
Parse, Bind, Optimize, Execute
  • Home
  • SQL Queries
  • Oracle
  • Oracle BI
  • Unix
  • Postgresql
  • Interview Q/A
SQL WORLD
Parse, Bind, Optimize, Execute

Categories

Category: SQL Tutorials

SQL Tutorials

How to use execute immediate statements in oracle? | Dynamic SQL -1

Amit S March 23, 2021 No Comments

In my previous article I have given the details about Oracle PL SQL in detail. In this article i would like to brief about the…

View More How to use execute immediate statements in oracle? | Dynamic SQL -1
SQL Tutorials

How to connect to oracle database using sql developer

Amit S February 15, 2021 No Comments

In my previous article i have already given the difference between the Oracle anonymous block and subprogram with real life examples. In this article I…

View More How to connect to oracle database using sql developer
SQL Tutorials

How to connect to Oracle database using Sys user?

Amit S November 23, 2020 No Comments

How to connect to Oracle database using Sys user? In my previous article I have given multiple SQL queries. In this article I would like…

View More How to connect to Oracle database using Sys user?
SQL Tutorials

How to take backup of Oracle database Schema?

Amit S October 5, 2020 No Comments

In my previous articles i have given the basic idea about multiple oracle interview questions and advanced interview questions. In this article i would like…

View More How to take backup of Oracle database Schema?
SQL Tutorials

Is SQL a Programming Language?

Amit S September 2, 2020 2 Comments

In my previous articles i have given so many complex sql queries for reference. I have seen that the common question is in mind of…

View More Is SQL a Programming Language?
SQL Difference Between SQL Tutorials

What is Difference between %type and %rowtype with examples?

Amit S August 20, 2020 No Comments

I have written so many articles on SQL difference between subject. I would like to focus on Difference between %TYPE and %ROWTYPE in this article.…

View More What is Difference between %type and %rowtype with examples?
SQL Tutorials

How to check database uptime?

Amit S August 19, 2020 No Comments

In my previous articles i have given many answers about how to related to oracle and sql server as well. In this article i would…

View More How to check database uptime?
SQL Tutorials

What is Oracle DATEDIFF function with examples?

Amit S August 19, 2020 No Comments

In my previous article I have provided the different date functions and its real life industry examples. In this article i would like to give…

View More What is Oracle DATEDIFF function with examples?
SQL Tutorials

How to set oracle_home path?

Amit S August 19, 2020 No Comments

In my previous article i have given the detailed description of multiple queries related to oracle. In this article i would like to throw light…

View More How to set oracle_home path?
SQL Complex Queries SQL Tutorials

How to create duplicate table in SQL? | Creating duplicate table

Amit S August 18, 2020 No Comments

In previous article i have given the basic idea about how to create a table in SQL. In this article i would like to give…

View More How to create duplicate table in SQL? | Creating duplicate table

Posts navigation

Page 1 Page 2 … Page 12 Next page

Recent Posts

  • Oracle Kill Job Steps | How to kill Oracle job with Examples?
  • How to create Oracle database link with example?
  • How to send mail using UTL_MAIL package in PL/SQL?
  • How to create External Audit table in oracle?
  • How to write row level trigger with examples?

Like Us on Facebook

Like Us on Facebook

Categories

  • BI Tutorials
  • Data Mining
  • Data Modeling Interview Questions
  • ITIL Certification
  • OCA Preparation
  • Oracle 18c
  • Oracle Errors
  • Oracle Upgrade
  • PLSQL Tutorials
  • PostgreSQL
  • Roles and Responsibilities
  • Scrum Master
  • SQL Complex Queries
  • SQL Difference Between
  • SQL Interview Questions
  • SQL Interview Questions For Freshers
  • SQL Joins
  • SQL Performance Tuning
  • SQL Practice Quiz
  • SQL Tutorials
  • Unix Interview Questions
  • Unix Tutorials

Tags

Basic SQL Queries Complex View difference between simple view and complex view Equi join Inner Join Logical table in SQL Non Equi Join Oracle Outer Join PLSQL Postgres Self Join Simple View SQL SQL Joins SQL Views View Views in SQL
  • Home
  • About Us
  • Privacy Policy
  • Contact Us
SQL WORLD | Designed by: Theme Freesia | WordPress | © Copyright All right reserved