Below are the examples to check if a record exists using PL/SQL in Oracle. Check if record exists using the Count() function The following Oracle PL/SQL block will use the count() function in implicit cursor to count the records for ...
Home/Blog
Discy Latest Articles
Oracle Apex: Master-Detail Form Example on EMP and DEPT Tables
VinishIn this tutorial, you will learn how to create a master-detail form in Oracle Apex based on SCOTT schema’s EMP and DEPT tables. If you don’t have the SCOTT schema installed, or do you need only the EMP and DEPT ...
Oracle: Running a Procedure in Background
VinishIn this Oracle tutorial, you will learn how to run a procedure in the background using DBMS_SCHEDULER. Running a procedure in the background means that the stored procedure will run asynchronously. You can run multiple procedures in the background, which ...
Oracle Apex: Dynamic Action to Show/Hide Region
VinishIn this Oracle Apex tutorial, I will show you how to create a dynamic action to show/hide a region on the Select List change event. We have an item P4_SHOWHIDE as a Select List on page 4, containing static values ...
Free APEX Plugins
Ashish SahayOracle Apex, a framework that provides rapid development and deployment. To engage the same practice APEX plugins are most useful where you can just create/install the plugins and reuse them across the application. MIT License free-forever plugins. Download Move item ...
Displaying Error Messages using JavaScript API in Oracle Apex
VinishIn this tutorial, I will show you how you can validate an item on lost focus event and display the custom error messages using the JavaScript API apex.message.showErrors() method in Oracle Apex. Display Error Messages using JavaScript in Oracle Apex ...
How to Create a Table in Oracle Apex?
VinishYou can create a table in Oracle Apex using the Object Browser or SQL Commands option from the SQL Workshop menu. Below are the examples: Follow these steps to create a table using object browser in Oracle Apex Start Oracle ...
How to Find Tablespace Used by a User in Oracle
VinishYou can use the user_tablespaces dictionary view to get the tablespace used by a user in Oracle. Below is an example: SQL Query to Find Tablespace Used by a user in Oracle The following SQL query will not only return ...
How to Export Schema using Oracle SQL Developer
VinishIn this tutorial, you will learn how to export schema using Oracle SQL Developer. Exporting schema in Oracle is we are exporting DDL statements for the objects. You can export the schema with data or without the data, all objects, ...
Oracle: Getting Current Table Size and Extent Information
VinishIn Oracle, you can use the user_extents and user_tables dictionary views to get the current table size and extent information. Below is an example: Oracle SQL Query to Get the Current Table Size and Extent Information The following query returns ...