ORA-12154 is a common error in Oracle that indicates that there is a problem with the TNS configuration. The most common cause of this error is an incorrect or incomplete TNS entry in the tnsnames.ora file. To fix this error, ...
Discy Latest Articles
Can Oracle Database Run on MAC?
Vinish KapoorThe straightforward answer is No. You can not run Oracle Database on MAC OS. Oracle Database is a relational database management system (RDBMS) that stores data in tables and other objects. Oracle Database can run on Windows, Linux, and UNIX ...
What is Oracle ERP?
Vinish KapoorOracle Enterprise Resource Planning (ERP) software is a system that streamlines and automates business processes. Businesses use Oracle ERP to standardize accounting practices, manage supply chains, and streamline daily operations. Oracle ERP integrates business functions, such as manufacturing, financial management, ...
Oracle Convert Float to Integer
Vinish KapoorYou 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
Vinish KapoorIn 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
Vinish KapoorIn 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
Vinish KapoorIn 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 ] [ { { ...