• 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

condition

IS NOT NULL in Oracle SQL PLSQL

November 22, 2012 by techhoneyadmin

In Oracle SQL / PLSQL IS NOT NULL is used to check whether the value of a literal IS NOT NULL or not. Example 1: Syntax to use IS NOT NULL in IF statement is: IF literal_name IS NOT NULL THEN <business_logic> END IF; Here if the literal_name does not have NULL value then the […]

Filed Under: condition Tagged With: how to use IS NOT NULL in oracle database query, how to use IS NOT NULL in oracle plsql, how to use IS NOT NULL in oracle sql, IS NOT NULL in oracle plsql, IS NOT NULL in oracle sql, ISNOTNULLPLSQL, syntax and example of IS NOT NULL in oracle database query, syntax and example of IS NOT NULL in oracle plsql, syntax and example of IS NOT NULL in oracle sql, using IS NOT NULL in oracle database query, using IS NOT NULL in oracle plsql, using IS NOT NULL in oracle sql

IS NULL in Oracle SQL PLSQL

November 22, 2012 by techhoneyadmin

In Oracle SQL / PLSQL IS NULL is used to check whether the value of a literal is NULL or not. Example 1: Syntax to use IS NULL in IF statement is: IF literal_name IS NULL THEN <business_logic> END IF; Here if the literal_name has NULL value then the IF condition will evaluate to TRUE, […]

Filed Under: condition Tagged With: how to use IS NULL in oracle database query, how to use IS NULL in oracle plsql, how to use IS NULL in oracle sql, IS NULL in oracle plsql, IS NULL in oracle sql, ISNULLPLSQL, syntax and example of IS NULL in oracle database query, syntax and example of IS NULL in oracle plsql, syntax and example of IS NULL in oracle sql, using IS NULL in oracle database query, using IS NULL in oracle plsql, using IS NULL in oracle sql

LIKE Condition in Oracle SQL -PLSQL

October 24, 2012 by techhoneyadmin

The LIKE condition in Oracle SQL / PLSQL is used in WHERE clause to place wildcard characters while fetching records. LIKE condition can be used with SELECT, INSERT, UPDATE and DELETE in SQL statements. LIKE condition have 2 flavors: 1. % – allows us to match string of any length including zero length. 2. _ […]

Filed Under: condition Tagged With: how to use like condition in oracle database query, how to use like condition in oracle plsql, how to use like condition in oracle sql, like condition in oracle plsql, like condition in oracle sql, LIKEConditionPLSQL, syntax and example of like condition in oracle database query, syntax and example of like condition in oracle plsql, syntax and example of like condition in oracle sql, using like condition in oracle database query, using like condition in oracle plsql, using like condition in oracle sql

EXISTS Condition in Oracle SQL – PLSQL

October 24, 2012 by techhoneyadmin

The EXISTS condition in Oracle SQL / PLSQL will return any records whenever the “exists” condition is met. EXISTS condition can be used with SELECT, INSERT, UPDATE and DELETE SQL statements. Syntax for the EXISTS condition in Oracle SQL / PLSQL is: SELECT column_name(s) FROM table_name WHERE EXISTS (subquery); Or INSERT INTO table_name VALUES(column_name1 ,column_name2 […]

Filed Under: condition Tagged With: exists condition in oracle plsql, exists condition in oracle sql, EXISTSConditionPLSQL, how to use exists condition in oracle database query, how to use exists condition in oracle plsql, how to use exists condition in oracle sql, syntax and example of exists condition in oracle database query, syntax and example of exists condition in oracle plsql, syntax and example of exists condition in oracle sql, using exists condition in oracle database query, using exists condition in oracle plsql, using exists condition in oracle sql

BETWEEN Condition in Oracle SQL – PLSQL

October 24, 2012 by techhoneyadmin

The BETWEEN condition in Oracle SQL / PLSQL allows us to filter the records within a range of values including values provided for the range. BETWEEN condition can be used with SELECT, INSERT, UPDATE and DELETE SQL statements. Syntax for the BETWEEN condition in Oracle SQL / PLSQL is: SELECT column_name(s) FROM table_name WHERE column_name […]

Filed Under: condition Tagged With: between condition in oracle plsql, between condition in oracle sql, BETWEENConditionPLSQL, how to use between condition in oracle database query, how to use between condition in oracle plsql, how to use between condition in oracle sql, syntax and example of between condition in oracle database query, syntax and example of between condition in oracle plsql, syntax and example of between condition in oracle sql, using between condition in oracle database query, using between condition in oracle plsql, using between condition in oracle sql

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

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