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

Oracle TIMESTAMP data type

August 18, 2024November 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

August 18, 2024November 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
Oracle PL SQL

Select distinct Values without using DISTINCT keyword

August 18, 2024January 29, 2023 Viswanath A

Distinct Values – Learn how to select distinct values in a table with and Without using SQL DISTINCT keyword with example queries. Below is the DUP_VALUES_TBL 

Read More
Oracle PL SQL Uncategorized

Replace oracle function

August 18, 2024November 12, 2019 Viswanath A

Learn how to replace matching string with another string using replace function with example queries. REPLACE function replaces a search string with replacement string. Syntax

Read More
Oracle PL SQL

REGEXP_REPLACE oracle 10g feature

August 18, 2024November 11, 2019 Viswanath A

Learn how to replace a string with another string using REGEXP_REPLACE with example queries. REGEXP_REPLACE -replace all occurrences of a substring that match a regular

Read More
Oracle PL SQL

REGEXP_COUNT – Oracle 11g feature

August 18, 2024November 11, 2019 Viswanath A

Learn how to count the number of occurrences of the given sub-string present in the input string with example queries. REGEXP_COUNT returns the number of

Read More
Oracle PL SQL

REGEXP_SUBSTR oracle 10g feature

August 18, 2024November 11, 2019 Viswanath A

Learn how extract a sub-string from the given input string with example queries. REGEXP_SUBSTR function is an extension of the SUBSTR function. REGEXP_SUBSTR extractS a

Read More
Oracle PL SQL

REGEXP_INSTR Oracle Regular Expression.

August 18, 2024November 7, 2019 Viswanath A

Learn how to find the position of a matching character or a matching string from the input string using INSTR function with example queries. REGEXP_INSTR

Read More
Oracle PL SQL

REGEXP_LIKE – oracle regular expression

August 18, 2024January 28, 2023 Viswanath A

Learn how to retrieve the matching strings from the table using pattern matching with regular expressions. The Oracle REGEXP_LIKE condition allows you to perform regular

Read More
Oracle PL SQL

Oracle-Regular Expression

August 18, 2024October 30, 2019 Viswanath A

Learn about pattern matching and pattern to be searched for within a longer piece of text. Regular Expression A sequence of symbols and characters expressing

Read More

Posts pagination

Previous 1 … 3 4 5 … 9 Next

My Unique Books for YOU

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