• 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

function

Oracle TO_DATE Function

November 28, 2012 by techhoneyadmin

Oracle TO_DATE Function

Oracle TO_DATE function is used to convert string type into date type. Oracle SQL TO_DATE examples and syntax can be found below. Oracle TO_DATE Function Syntax SELECT TO_DATE (STRING_VALUE, [FORMAT_MASK],[NLS_LANGUAGE]) FROM table_name; In the above Oracle TO_DATE Function Syntax: STRING_VALUE is the value that will be converted into date format. FORMAT_MASK is an optional field, if […]

Filed Under: function Tagged With: how to convert to date type in oracle sql, oracle sql plsql to date function, oracle sql to date function syntax and example, TODATEPLSQL

USERENV Function in Oracle SQL – PLSQL

November 28, 2012 by techhoneyadmin

Oracle SQL / PLSQL USERENV function is used to get the information about the current Oracle Session. Oracle SQL / PLSQL syntax for the USERENV function is: SELECT USERENV (parameter) FROM table_name; The parameter is the value that is passed to the USERENV function. The possible values of parameter are shown below: Parameter Explanation CLIENT_INFO […]

Filed Under: function Tagged With: how to get the information about the current oracle sql session using USERENV function, How to use oracle sql plsql USERENV function with example, USERENVPLSQL, What is oracle sql plsql USERENV function

UID Function in Oracle SQL – PLSQL

November 28, 2012 by techhoneyadmin

Oracle SQL / PLSQL uses the UID function to get the id number of the user’s session for the user who is currently logged in. Orace SQL / PLSQL syntax for the UID function is: SELECT UID FROM table_name; Example: Using Oracle SQL UID function in SQL SELECT Statement May return ‘5’ or ’15’ or […]

Filed Under: function Tagged With: how to get the id number of the current user using the UID oracle sql plsql function, How to use oracle sql plsql UID function with example, UIDPLSQL, What is oracle sql plsql UID function

NULLIF Function in Oracle SQL – PLSQL

November 28, 2012 by techhoneyadmin

Oracle SQL / PLSQL used the NULLIF function to compare 2 expressions. If the expressions are equal then the SQL NULLIF function returns NULL, else SQL NULLIF function will return the first expression. Oracle SQL / PLSQL Syntax for the NULLIF function is: SELECT NULLIF (expression_1, expression_2) FROM table_name; Here, expression_1 and expression_2 are the […]

Filed Under: function Tagged With: Compare two expressions usin oracle sql plsql NULLIF function, How to use NULLIF function in oracle sql plsql with example, NULLIFPLSQL

NANVL Function in Oracle SQL – PLSQL

November 28, 2012 by techhoneyadmin

Oracle SQL / PLSQL NANVL function allows us to substitute a value for a floating point number such a BINARY_FLOAT or BINARY_DOUBLE, when an SQL Not A Number (NAN) value is encountered. The Oracle SQL NANVL function is most commonly used to convert Not A Number (NAN) values to either 0 or NULL. Oracle SQL […]

Filed Under: function Tagged With: how to substitute 0 or NULL for floating number using oracle sql NANVL function, How to use oracle sql plsql NANVL function with example, NANVLPLSQL, What is oracle sql plsql NANVL function

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

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