In this tutorial, you will learn how to create a page as a copy of another page in the Oracle Apex application. Oracle Apex - Steps to Create a Page as Copy of Another Page To create a page as ...
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
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 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, ...
How to Get GMT in Java?
Here is an example of a Java program to get GMT: Java - Get GMT Example import java.util. *; import java.text. *; public class GetGMTTime { public static void main(String[] args) { SimpleDateFormat df = new SimpleDateFormat("yyyy MMM dd HH:mm:ss ...
NetBeans - Fix JDK is Missing Error on Mac
You are starting NetBeans on Mac and getting the error "JDK is missing...". To fix this error, follow these steps: Steps to Fix JDK is Missing Error on Mac for NetBeans Open the Terminal app and execute the following command ...
How to Find Oracle Apex Port
Here is an example of an Oracle SQL query to find the Oracle Apex port number. Find Oracle Apex Port You can find the Oracle Apex port number using the dbms_xdb.gethttpport() function. Below is an example: select dbms_xdb.gethttpport from dual; ...
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 ...
Oracle SQL Query to Get Day from Date
Here are the examples of Oracle SQL queries to get the day from date. SQL Query to Get Full Day Name from the Date select to_char(sysdate, 'DAY') full_name from dual; Output: SUNDAY To Get Short Day Name select ...
Oracle SQL Query to Split a String
The following are examples to split a string in Oracle using SQL query. Split a String Using regexp_substr() Function in Oracle The below query will split the string separated by comma using regexp_substr() function: select regexp_substr('A,B,C,D', '[^,]+', 1, level) from ...
Oracle Convert Float to Integer
You can use the CAST() function in Oracle to convert float to integer. Also, you can use an integer data type variable in PL/SQL. Below are the examples. Oracle CAST() Function Example to Convert Float to Ineger select cast(2.330 as ...
Oracle Convert Boolean to String
In Oracle, there is no function available to convert boolean to string (varchar2). You will have to use IF, CASE, or DECODE statement. The following is a PL/SQL program to convert boolean to varchar2 string: Example declare b_var boolean := ...
Oracle Convert Timestamp to Date
In Oracle, to get the current timestamp, use SYSTIMESTAMP, and if you want to convert timestamp to date, use the CAST() function. Below is an example: Using CAST() Function to Convert Timestamp to Date in Oracle The following is the ...
PL/SQL Character Set
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 ...
Pro*C - Connect to Oracle Database
Here 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 ...