Skip to content

Interview Sansar

Software jobs interview preparation source

  • Home
  • Interview Questions
    • C Interview Questions
    • C++ Advanced Interview Questions
    • C++ Basic Interview Questions
    • Core Java Interview Questions
    • Java Collections Interview Questions
    • Java Multithreading Interview Questions
    • C# Basic Interview Questions
    • C# Advanced Interview Questions
    • C# Multi-threading Interview Questions
  • MCQs
    • MCQ-C++
    • MCQ-Java
    • MCQ-SQL
    • MCQs Algorithms and Data Structure
  • Programming Examples
    • C Programming Examples
    • C++ Programming Examples
    • C# Programming Examples
    • SQL Examples
    • Oracle PL SQL Examples
    • Time Complexity
  • Blog
    • C++ interview questions
    • C# interview questions
    • Java Interview Questions
    • Short Interview Questions
    • Behavioural / HR Interview
  • You-Tube
  • About
    • Why Visit
    • Sitemap
    • Contact Us
    • e-author

Category: Oracle PL SQL

Oracle PL SQL Tutorial Examples and Queries.

Oracle PL SQL

NULL vs Empty string in oracle

February 18, 2020 Viswanath A

Learn about NULL value and an empty string behavior in oracle database with example queries. NULL means no-value(nothing). An empty string(”) treated as NULL value

Read More
Oracle PL SQL

Rowid vs Rownum vs Row_Number() in oracle.

January 6, 2020January 28, 2023 Viswanath A

Learn the about the logical columns that are not exist in the table, but how can be used to select the data from the table,

Read More
Oracle PL SQL

Pseudo columns in Oracle

January 6, 2020January 28, 2023 Viswanath A

Learn about the logical columns that exists in oracle database with example queries. Pseudo columns are nothing but logical columns which behaves like a physical

Read More
Oracle PL SQL

Identify columns with NULL values

December 30, 2019 Viswanath A

Learn how to identify the columns present with NULL values in the table with example queries. There can be different ways to identify the columns

Read More
Oracle PL SQL

Remove duplicate records using dynamic SQL

December 30, 2019January 28, 2023 Viswanath A

Learn how to remove duplicate records present in a table with standard sql queries and also dynamic sql with example queries. For base table reference

Read More
Oracle PL SQL

Row limiting clause TOP ROWNUM LIMIT FETCH

December 23, 2019January 28, 2023 Viswanath A

Learn how to fetch top N rows using SQL TOP, ROWNUM, LIMIT, FETCH clauses with example queries. Row Limiting clause is useful to limit the

Read More
Oracle PL SQL

SQL practice test queries on Employee data in relational table

December 3, 2019 Viswanath A

Learn how to write SQL queries for questions given below. Queries are based on the Employee and Incentives tables given below. Let’s prepare the both

Read More
Oracle PL SQL

Extract function with DATE TIME data type values

November 19, 2019 Viswanath A

Learn how to extract a DAY,MONTH,YEAR,HOUR,MINUTE AND SECOND from a date time data type values. EXTRACT function extracts a date or a timestamp and returns

Read More
Oracle PL SQL

Oracle TIMESTAMP data type

November 18, 2019 Viswanath A

Learn how to use a Time stamp data type ,how to convert a Time stamp in string format to a string Timestamp format using TO_TIMESTAMP

Read More
Oracle PL SQL

Oracle DATE data type

November 13, 2019 Viswanath A

Learn how to convert a date in string format to a string Date format using TO_DATE function and Date literal formats. Also Learn how to

Read More

Posts navigation

1 2 … 9 Next

My Unique Books for YOU

All Rights Reserved 2023: Interview Sansar.
Proudly powered by WordPress | Theme: Fairy Blog by Candid Themes.