Decode Vs Case
DBARepublic.com • 9:04 AM
DECODE OR CASE - You make a Case! Decode is a function that compares the expression to each search value one by one. if the search is foun...Read More
Search results for plsql
IF EXISTS Equivalent
DBARepublic.com • 8:40 AM
DROP TABLE baniya.emp; What is one problem you can think of when using a DROP statement inside a SQL script? The drop command drops tabl...Read More
Implicit Cursor
DBARepublic.com • 11:01 AM
A cursor is a work area or a section of memory in which SQL statements are processed in the Oracle server. A cursor is a pointer to a privat...Read More
Explicit Cursor
DBARepublic.com • 11:15 AM
A Cursor is a work area or a section of memory in which SQL statements are processed in the Oracle server. A cursor is a pointer to a privat...Read More
Checking Oracle Error
DBARepublic.com • 3:45 PM
How to Look up Oracle Error Code ? ORACLE Database is very notorious at throwing error messages for everything. Error code and messages...Read More
Subscribe to:
Posts
(
Atom
)
