Here are examples of Oracle SQL queries to find substring in a string. Find Substring in a String Using INSTR() Function Examples In Oracle, the instr() function returns the position of a substring in the string. So if the substring ...
Discy Latest Articles
Oracle SQL Query to Fetch First n Rows
Here are examples of Oracle SQL queries to fetch first n rows. Oracle SQL - Fetch First n Rows Examples You can use the FETCH FIRST clause to get the first/top n rows in Oracle. Below is an example: SELECT ...
Oracle SQL Query to Get Invalid Objects
Here are examples of Oracle SQL queries to get invalid objects. Get Invalid Objects of Current User in Oracle To get the list of invalid objects for the current logged in user, run the following SQL query: Select object_name, object_type, ...
Oracle SQL Query to Join Two Tables
Here are the examples of Oracle SQL queries to join two tables. Using INNER JOIN to Join Two Tables in Oracle The following SQL query will join the emp and emp_docs table using the INNER JOIN clause: select e.first_name, e.last_name, ...
Oracle SQL Query to Check User Permissions
Here are the examples of Oracle SQL queries to check user permissions. Check Current User Permissions in Oracle If you want to check the user permissions for the currently logged in user, run the following SQL queries: select * from ...
Oracle SQL Query to Exclude Weekends
Here are the examples of Oracle SQL queries to exclude weekends from a date range. Suppose you are querying a table to get the data for a particular date range, and you want to exclude the weekends. Below is an ...
Oracle SQL Query to Get Column Length
The following are examples of Oracle SQL queries to get the column length. Get Column Length using the length() and dbms_lob.getlength() Functions in Oracle Below is the SQL query which uses the length() function to get the length of a ...
Oracle SQL Query to Get Current Month Data
Here are examples of Oracle SQL queries to get the current month data. Oracle SQL - Get Current Month Data Examples The following example will compare the order date with SYSDATE's month and year using the to_char() function. select * ...
Oracle Convert String to Date
Here are some examples of Oracle SQL queries to convert string to date. Oracle to_date() Function Examples to Convert String to Date To convert a string to date, you will have to follow the same date format in which your ...
Oracle SQL Query to Get Data for a Particular Date
Here are the examples of Oracle SQL queries to get data for a particular date. Get Data from Oracle Table for a Particular Date To get data from the Oracle table for a particular date: select * from demo_orders where ...