Check the USER_TRIGGERS table, you can get the Trigger status easily :

Date: 2019-08-11 View: 1520

This article shows you how to use DROP FUNCTION to delete a function from Oracle database.

Date: 2019-08-11 View: 1520

This article shows you how to use BEFORE DELETE TRIGGER, it will fire before the delete operation is executed. In real life scenarios, it is mostly used for purposes like:

Date: 2019-08-11 View: 1520

This article shows you how to use INSTEAD OF TRIGGER to update

Date: 2019-08-11 View: 1520

This ABS() function returns absolute value of a number, for example, the absolute value of 5 is 5, and the absolute value of -5 is also 5. In Mathematics, absolute value can be think of as a distance from zero.

Date: 2019-08-11 View: 1520

The ASIN() function returns arc sine of input n, the input n must be in the range of -1 to 1. The function will return a value in the range of -pi/2 to pi/2, expressed in radians.

Date: 2019-08-11 View: 1520

The ACOS() function returns the arc cosine of input n, the input n must be in the range of -1 to 1. The function will return a value in the range of 0 to pi, expressed in radians.

Date: 2019-08-11 View: 1520

The FLOOR() function round the specified number down, and return the largest number that is less than or equal to the specified number.

Date: 2019-08-11 View: 1520

The CEIL function round the specified number up, and return the smallest number that is greater than or equal to the specified number.

Date: 2019-08-11 View: 1520

This article show you how to use ATAN() and ATAN2() function in Oracle PL/SQL.

Date: 2019-08-11 View: 1520

The BITAND function treats its inputs and its output as vectors of bits, the output is the bitwise AND of the inputs.

Date: 2019-08-11 View: 1520

This article will help you to understand how to create a user defined function. It’s also known as stored function or user function.

Date: 2019-08-11 View: 1520

How to Uninstall Oracle Database 19c on Windows

To uninstall Oracle database on Windows, we have to delete the all the related Ora* registry keys, files and folders manually.

Date: 2019-08-11 View: 1520

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

This is caused by the requested SID doesn’t exist in {ORACLE_HOME}/network/admin/tnsnames.ora

Date: 2019-08-11 View: 1520

Spring Boot JDBC Stored Procedure Examples

In this tutorial, we will show you how to use Spring Boot JDBC SimpleJdbcCall to call a stored procedure and stored function from a Oracle database.

Date: 2019-08-11 View: 1520