A PL/SQL program is a sequence of statements, contains multiple lines of text. The types of characters available depend on the database character set you’re using. To know your current Oracle Database character set, run the following SQL statement: Get ...
Home/OrclDB
vinish.ai Latest Articles
Pro*C – Connect to Oracle Database
VinishHere is an example of the Pro*C program to connect to the Oracle Database. Pro*C Program Example – Connect to Oracle Database The below Pro*C program will connect to the Oracle database and will execute the stored procedure YourDBProc. #include ...
Oracle PL/SQL: Check if record exists
VinishBelow 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 ...
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 ...
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 ...
Oracle: Get DDL for Constraints using dbms_metadata.get_ddl() Function
VinishSometimes there is a requirement to get the DDL statement for constraints only in Oracle. To do this you can use the dbms_metadata.get_ddl() function. Below are the examples: Get DDL for Constraints using dbms_metadata.get_ddl() Function in Oracle Below is an ...
Oracle Create Table Storage Clause Example
VinishHere is a simple example of how you can create a table in Oracle using the storage clause. The following is the syntax of Create Table command in Oracle using the Storage clause: Syntax Create Table (column1 data_type, column2 data_type) ...