Oracle Installed Base is an item instance life cycle tracking application that facilitates enterprise-wide life cycle item management and tracking capability.You specify which items you want to track in the Master Item list in Oracle Inventory. Subsequently, when a particular real-world instance of the item is created, an item instance record is created in Oracle […]
To create a periodic alert, you perform the following tasks in the order listed: Define your periodic alert and specify its frequency. Specify the details for your alert. Define actions for your alert. Create action sets containing the actions you want your alert to perform. Before you define a periodic alert, make sure you do […]
Event AlertsEvent alerts immediately notify you of activity in your database as it happens. You define what a database event is – an insert or an update to a table – and Oracle Alert informs you when it happens. You can modify our precoded alert conditions or simply create your own, and Oracle Alert will […]
NVLThe NVL() function is available in Oracle, and not in MySQL or SQL Server. This function is used to replace NULL value with another value. It is similar to the IFNULL Function in MySQL and the ISNULL Function in SQL Server. The syntax for the NVL function is: NVL( string1, replace_with ) string1 is the […]
UNION QueryThe UNION query allows you to combine the result sets of 2 or more “select” queries. It removes duplicate rows between the various “select” statements. Each SQL statement within the UNION query must have the same number of fields in the result sets with similar data types. The syntax for a UNION query is:Select […]
Recent Comments