• 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

statement

EXIT Statement in Oracle PLSQL

November 23, 2012 by techhoneyadmin

EXIT statement in Oracle PLSQL is most commonly used to end the LOOP statement’s execution. The Syntax for the EXIT Statement in Oracle PLSQL is: EXIT [WHEN boolean_condition]; Example of an EXIT Statement in Oracle PLSQL is: The above loop will execute the “sum := sum+1; statement 35 times. The loop will start counting from […]

Filed Under: statement Tagged With: EXIT Statement in oracle plsql, EXIT Statement in oracle sql, EXITSTATEMENTPLSQL, how to use EXIT Statement in oracle database query, how to use EXIT Statement in oracle plsql, how to use EXIT Statement in oracle sql, syntax and example of EXIT Statement in oracle database query, syntax and example of EXIT Statement in oracle plsql, syntax and example of EXIT Statement in oracle sql, using EXIT Statement in oracle database query, using EXIT Statement in oracle plsql, using EXIT Statement in oracle sql

GOTO Statement in Oracle PLSQL

November 23, 2012 by techhoneyadmin

A GOTO Statement in Oracle PLSQL is used to redirect the code execution to a “Label” as specified in the GOTO statement. Syntax of the GOTO Statement in Oracle PLSQL is: GOTO label_name; Somewhere further in the code, we need to place the label “label_name” and provide the code to be executed. Example of GOTO […]

Filed Under: statement Tagged With: GOTO Statement in oracle plsql, GOTO Statement in oracle sql, GOTOSTATEMENTPLSQL, how to use GOTO Statement in oracle database query, how to use GOTO Statement in oracle plsql, how to use GOTO Statement in oracle sql, syntax and example of GOTO Statement in oracle database query, syntax and example of GOTO Statement in oracle plsql, syntax and example of GOTO Statement in oracle sql, using GOTO Statement in oracle database query, using GOTO Statement in oracle plsql, using GOTO Statement in oracle sql

CASE Statement in Oracle SQL PLSQL

November 23, 2012 by techhoneyadmin

A CASE Statement in Oracle SQL / PLSQL is having the functionality of IF-THEN-ELSE Statement. Syntax of the CASE Statement in Oracle SQL / PLSQL is: CASE [expression] WHEN condition_1 THEN result_1 WHEN consition_2 THEN result_2 WHEN condition_3 THEN result_3 . . WHEN condition_N THEN result_N ELSE default_result END; expression is an optional value, if […]

Filed Under: statement Tagged With: CASE Statement in oracle plsql, CASE Statement in oracle sql, CASESTATEMENTPLSQL, how to use CASE Statement in oracle database query, how to use CASE Statement in oracle plsql, how to use CASE Statement in oracle sql, syntax and example of CASE Statement in oracle database query, syntax and example of CASE Statement in oracle plsql, syntax and example of CASE Statement in oracle sql, using CASE Statement in oracle database query, using CASE Statement in oracle plsql, using CASE Statement in oracle sql

IF THEN ELSE Statement in Oracle PLSQL

November 23, 2012 by techhoneyadmin

An IF-THEN-ELSE Statement in Oracle PLSQL is basically a conditional statement that evaluates an expression, if the expression evaluates to true, then the ‘THEN’ portion of the code is executed, if the expression evaluates to false, then ‘ELSE’ part of the code gets executed. There are 3 syntaxes of IF-THEN-ELSE Statement in Oracle PLSQL: Syntax […]

Filed Under: statement Tagged With: how to use IF THEN ELSE Statement in oracle database query, how to use IF THEN ELSE Statement in oracle plsql, how to use IF THEN ELSE Statement in oracle sql, IF THEN ELSE Statement in oracle plsql, IF THEN ELSE Statement in oracle sql, IFTHENELSESTATEMENTPLSQL, syntax and example of IF THEN ELSE Statement in oracle database query, syntax and example of IF THEN ELSE Statement in oracle plsql, syntax and example of IF THEN ELSE Statement in oracle sql, using IF THEN ELSE Statement in oracle database query, using IF THEN ELSE Statement in oracle plsql, using IF THEN ELSE Statement in oracle sql

Change User Password in SQL – PLSQL

October 31, 2012 by techhoneyadmin

In Oracle SQL / PLSQL a user’s password can be changed using ALTER command. Syntax for changing the user password using ALTER command in Oracle SQL / PLSQL is: ALTER USER user_name IDENTIFIED BY new_password; Example: Here we have changed the password for “techhoney” user as “pwdhoney”.

Filed Under: statement Tagged With: change user password in oracle plsql, change user password in oracle sql, ChangeUserPasswordPLSQL, how to use change user password in oracle database query, how to use change user password in oracle plsql, how to use change user password in oracle sql, syntax and example of change user password in oracle database query, syntax and example of change user password in oracle plsql, syntax and example of change user password in oracle sql, using change user password in oracle database query, using change user password in oracle plsql, using change user password in oracle sql

  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Go to Next Page »

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