|
|
Search criteria "plsql" returned 116 result(s). Documentation
|
|
In Oracle/PLSQL, the decode function has the functionality of an IF-THEN-ELSE statement.
|
|
|
|
In Oracle/PLSQL, the coalesce function returns the first non-null expression in the list. If all expressions evaluate to null, then the coalesce function will return null.
|
|
|
|
In Oracle/PLSQL, the NVL2 function extends the functionality found in the NVL function. It lets you substitutes a value when a null value is encountered as well as when a non-null value is encountered.
|
|
|
|
In Oracle/PLSQL, the sys_context function can be used to retrieve information about the Oracle environment.
|
|
|
|
In Oracle/PLSQL, the userenv function can be used to retrieve information about the current Oracle session. Although this function still exists in Oracle for backwards compatibility, it is recommended that you use the sys_context function instead.
|
|
|
|
Named system exceptions are exceptions that have been given names by PL/SQL. They are named in the STANDARD package in PL/SQL and do not need to be defined by the programmer.
|
|
|
|
Sometimes, it is necessary for programmers to name and trap their own exceptions - ones that aren't defined already by PL/SQL. These are called Named Programmer-Defined Exceptions.
|
|
|
|
In Oracle 9i, you can use the case statement within an SQL statement. It has the functionality of an IF-THEN-ELSE statement.
|
|
|
|
The SQLCODE function returns the error number associated with the most recently raised error exception. This function should only be used within the Exception Handling section of your code.
|
|
|
|
The SQLERRM function returns the error message associated with the most recently raised error exception. This function should only be used within the Exception Handling section of your code.
|
|
|
|
|
|
|
|
|
|
Page Views
|
|
714 today
|
|
2,100 yesterday
|
|
118,787 last month
|
|
13,155,977 total
|
|
|
|
