• Skip to primary navigation
  • Skip to main content

Tech Honey

The #1 Website for Oracle PL/SQL, OA Framework and HTML

  • Home
  • HTML
    • Tags in HTML
    • HTML Attributes
  • OA Framework
    • Item in OAF
    • Regions in OAF
    • General OAF Topics
  • Oracle
    • statement
    • function
    • clause
    • plsql
    • sql

plsql

Synonyms in Oracle SQL PLSQL

December 21, 2012 by techhoneyadmin

Oracle SQL / PLSQL uses synonym as an alias for any database object such as tables, views, sequences, stored procedures, and other database object. In other words we can say that in Oracle SQL / PLSQL a synonym is an alternative name for database objects. Oracle SQL / PLSQL syntax to create or replace a […]

Filed Under: plsql Tagged With: how to create synonym in oracle sql plsql syntax and example, how to drop synonym in oracle sql plsql syntax and example, synonymplsql, Synonyms in oracle sql plsql with example, what is synonym in oracle sql plsql with example

WHEN OTHERS CLAUSE in Exceptions in Oracle PLSQL

December 21, 2012 by techhoneyadmin

WHEN OTHERS CLAUSE in PLSQL Exceptions:- WHEN OTHERS CLAUSE in PLSQL Exceptions is used to capture an exception that’s not handled by our Named System Exception or Named Programmer Defined Exception. The plsql syntax for using WHEN OTHERS Clause in an Exception within a procedure is: CREATE [OR REPLACE] PROCEDURE procedure_name [ (parameter [,parameter]) ] […]

Filed Under: plsql Tagged With: EXCEPTIONHandlingPLSQL, how to write WHEN OTHERS Clause in exception in oracle plsql, Oracle plsql WHEN OTHERS Clause in exception handling, what is WHEN OTHERS Clause in exception handling, WHEN OTHERS Clause in exception handling in oracle plsql

Named Programmer Defined Exceptions in Oracle PLSQL

December 21, 2012 by techhoneyadmin

Oracle PLSQL exception is the condition that terminates the execution of plsql block. Named Programmer Defined Exception:- The named programmer defined exceptions are the plsql exceptions that are defined by a programmer to trap specific exceptions hence have been named. The named programmer defined plsql exceptions are not named in the standard package in plsql […]

Filed Under: plsql Tagged With: EXCEPTIONHandlingPLSQL, how to handle named programmer defined exception in oracle plsql, named programmer defined exception handling in oracle plsql, Oracle plsql named programmer defined exception handling, what is oracle plsql named programmer defined exception handling

Named System Exceptions in Oracle PLSQL

December 21, 2012 by techhoneyadmin

Oracle PLSQL exception is the condition that terminates the execution of plsql block. Named System PLSQL Exceptions:- The named system exceptions are the plsql exception that are encountered frequently and hence have been named for ease of use and that’s why they are called as named system exception. The named plsql exceptions are named in […]

Filed Under: plsql Tagged With: EXCEPTIONHandlingPLSQL, how to handle named system exception in oracle plsql, named system exception handling in oracle plsql, Oracle plsql named system exception handling, what is oracle plsql named system exception handling

Exception Handling in Oracle PLSQL

December 21, 2012 by techhoneyadmin

Oracle PLSQL exception can be termed as a condition that terminates the execution of plsql block. Oracle PLSQL gives us the functionality to handle the exception that can crop up in any Oracle PLSQL block and this functionality is called as Exception Handling. Using plsql exception handling we can avoid the code to end abruptly. […]

Filed Under: plsql Tagged With: exception handling in oracle plsql, EXCEPTIONHandlingPLSQL, how to handle exception in oracle plsql, Oracle plsql exception handling, what is oracle plsql exception handling

  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Interim pages omitted …
  • Go to page 5
  • Go to Next Page »

Copyright © 2023 · Parallax Pro on Genesis Framework · WordPress · Log in