In this tutorial, First, we would be discussing what is constraints and their types, and secondly, about the Oracle triggers and the usages before we could see the major difference between constraints and triggers. CONSTRAINTS: In Oracle, the constraints are ...
Discy Latest Articles
Oracle PL/SQL Download BLOB File to Disk
Here is an example of Oracle PL/SQL stored procedure to download BLOB file to disk. Oracle PL/SQL Stored Procedure Example to Download BLOB as File The following PL/SQL procedure takes three arguments. First, Oracle Directory object name, second, file name, ...
Oracle Convert External File to BLOB
Here is an example of the Oracle PL/SQL program to convert an external file to BLOB. Oracle PL/SQL Function Example to Convert an External File to BLOB In Oracle, you can reference an external file using the BFILENAME() function by ...
Oracle SQL Query to Find Substring in String
Are you looking to find specific words or pieces of text inside a longer text in Oracle SQL? Well, you're in the right place! In this quick tutorial, we'll show you how to use Oracle SQL to search for and ...
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
Want to keep your Oracle database running smoothly? You're in the right place! In this tutorial, we'll guide you through an essential Oracle SQL query that helps you identify invalid objects within your database. Discover how to ensure the integrity ...
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 * ...