Shortcut Keys (For Forms Developer) Description CTRL+J Connect to the database (Log in) F2 To view the Layout View F3 To view the Object Navigator (All the objects will be shown here ) F4 To view the object Property palette CTRL+D ...
Home/Oracle
Discy Latest Articles
Oracle Convert Float to Integer
VinishYou 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
VinishIn 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
VinishIn 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 ...
Oracle SELECT Statement
VinishIn Oracle, the SELECT statement is used to get the data from the tables, views, etc. The following is the syntax of the SQL SELECT statement: Oracle SELECT Statement Syntax [ with_clause ] SELECT [ hint ] [ { { ...