• Facebook
  • twitter
  • Instagram
Search

Srinimf

Tech. Jobs. Biz. Success

Menu
Skip to content
  • About Srini
  • Udemy
  • Jobs
  • Amazon
  • Contact us
  • Podcast

Category: Oracle

  • Oracle

Mastering SQL Loader: How to Load Dates with Ease

  • by Srini
  • Posted on February 25, 2023March 3, 2023

Here’s a sample Oracle SQL Loader control file logic when Dates are present in the input flat file.

Read More
  • Oracle

SQL Query: How to Check Index Space

  • by Srini
  • Posted on January 21, 2023January 21, 2023

Here are the top SQL queries how used to know index size. Explained views to refer to as a user /or as a DBA.

Read More
  • Oracle

5 Top Oracle Regexp Functions and their Usage

  • by Srini
  • Posted on September 17, 2022

The five top regular expression examples help you know the usage of these in Oracle SQL and PLSQL.

Read More
  • Oracle

How to Write Procedure and Function in PLSQL

  • by Srini
  • Posted on June 13, 2022December 12, 2022

A procedure also called subprogram explained how to use and call it in Oracle database

Read More
  • Oracle

Here’s the Oracle Scheduler Job Example

  • by Srini
  • Posted on May 21, 2022November 24, 2022

You can create and schedule a job in Oracle with the procedure you want. Here’s the best example for your reference

Read More
  • Oracle

How to Write SQL Query to Get Even and Odd Records

  • by Srini
  • Posted on April 30, 2022March 3, 2023

Here are SQL queries to fetch odd and even rows from a table in the Oracle database.

Read More
  • Oracle

How to Search Oracle Database for Column

  • by Srini
  • Posted on March 12, 2022March 15, 2022

Here is a helpful SQL query to find a Table name in the database for a column. Useful for error fixing or bug fixing.

Read More
  • Flashback

How to Recover Deleted Data in Oracle

  • by Srini
  • Posted on February 26, 2022November 30, 2022

Flashback table is an advanced concept in Oracle. With which you can recover data till a specific point in time. Here are the basic architecture and handy SQL queries that you need.

Read More
  • Oracle

Here is Logic to Write UDF to Check Input is Number or not

  • by Srini
  • Posted on December 6, 2021December 17, 2022

Here is a sample function that you can write in PL/SQL of Oracle. This function’s purpose is to check input if it is a number or not.

Read More
  • Oracle

How to Check if Table Exists in any RDBMS

  • by Srini
  • Posted on July 18, 2018May 22, 2021

Here’re top SQL queries you can use to check if Table exists or not. These are useful for Oracle SQL developers.

Read More
  • Oracle
  • Gallery

SQL Query, Here’s Best Example to Add Sequence Number

  • by Srini
  • Posted on July 14, 2017September 7, 2021

The well explained ideas in SQL query how you can include sequence is given here for your quick reference. These also useful for learning SQL.

Read More
  • Oracle

UPPER: Useful function in SQL to Convert to Upper-case

  • by Srini
  • Posted on June 15, 2017August 14, 2021

The syntax as given in Oracle built-in function, it is to convert lower case letters into upper case letters. The explanation given here is with examples. So that you use in your SQL program directly.

Read More

Posts navigation

Page 1 Page 2 Page 3 Next Page
Advertisements
Udemy APAC
Advertisements
Search your dream jobs here
Search your dream jobs here
Advertisements

About Srinimf

We share solutions for developer day to day problems and interview questions.

Blog Stats

  • 2,269,245 hits
© 2010-2023

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,959 other subscribers
Naturopathy Doctor
  • AWS
  • CentOS
  • Hadoop
  • IMS DC
  • Quiz
  • Blockchain
  • DB2
  • COBOL
  • Podcast
A WordPress.com Website.
×
  • Follow Following
    • Srinimf
    • Join 234 other followers
    • Already have a WordPress.com account? Log in now.
    • Srinimf
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
 

Loading Comments...
 

You must be logged in to post a comment.