Oracle Home

Oracle Home

For Everything Oracle and more

Menu

  • Home
  • Articles
  • About Me
  • Computer Book Reviews
  • New Computer Books

Oracle Built-in SQL Functions

You are here: Oracle Home > Oracle Built-in SQL Functions

To_clob – Oracle SQL Function

TO_CLOB converts character data to a CLOB. The string argument can be a CHAR, VARCHAR2, NCHAR NVARCHAR2, CLOB, or NCLOB data type. Example: SELECT TO_CLOB(‘SOME DATA’) as RESULT from DUAL; RESULT ———— SOME DATA

orahome 20/09/2018 Oracle Built-in SQL Functions Read more

To_date – Oracle SQL Function

TO_DATE converts a string to a DATE. The string argument can be a CHAR, VARCHAR2, NCHAR, or NVARCHAR2 data type. The format argument can be any valid date format. You can also specify the NLS_DATE_LANGUAGE parameter to change the language

orahome 20/09/2018 Oracle Built-in SQL Functions Read more

To_number – Oracle SQL Function

TO_NUMBER converts argument 1 toa NUMBER value. Syntax: TO_NUMBER(arg1,format,params) The arg1 argument can be a BINARY_FLOAT, BINARY_DOUBLE,CHAR,VARCHAR2,NCHAR, or NVARCHAR2 data type. The format parameter can be any valid date format. Valid options for the ‘params’ argument: NLS_NUMERIC_CHARACTERS = To specify

orahome 20/09/2018 Oracle Built-in SQL Functions Read more

Cardinality – Oracle SQL Function

CARDINALITY returns the number of records in a nested table. The function returns a NUMBER result. Example: SELECT ID,NAME,CARDINALITY(some_nested_table) FROM TABLE_NAME;

orahome 20/09/2018 Oracle Built-in SQL Functions Read more

Collect – Oracle SQL Function

COLLECT is used with the CAST function to create a nested table of the specified column name and cast it to the type specified in the CAST function. Example: SELECT CAST(COLLECT(some_column) as some_type) FROM table_name;

orahome 20/09/2018 Oracle Built-in SQL Functions Read more

Set – Oracle SQL Function

SET converts the nested table passed as an argument toa SET by removing any duplicate records from the table. Example: SELECT ID,NAME,SET(some_nested_table) FROM TABLE_NAME;

orahome 20/09/2018 Oracle Built-in SQL Functions Read more

Chartorowid – Oracle SQL Function

CHARTOROWID converts a string representation of a ROWID to a ROWID value. The string argument can be a CHAR,VARCHAR2,NCHAR, or NVARCHAR2 data type to ROWID data type. Example: SELECT ID from some_table WHERE ROWID = CHARTOROWID(‘AAAAtmAAEAAAAFmAAA’); ID —— 22

orahome 20/09/2018 Oracle Built-in SQL Functions Read more

Compose – Oracle SQL Function

COMPOSE allows you to compose a UNICODE string by passing in one or more code points. COMPOSE will add them all together and return the result. Example: SELECT COMPOSE(‘Let”s go to the cafe301 to get some tea.’)) as RESULT from

orahome 20/09/2018 Oracle Built-in SQL Functions Read more

Convert – Oracle SQL Function

CONVERT converts the string argument from one character set to another one. Syntax: CONVERT(string,destination_set, source_set) The source_set argument specifies the character set of the stored data in the database if ‘string’ is a column name, or the character set of

orahome 20/09/2018 Oracle Built-in SQL Functions Read more

Treat – Oracle SQL Function

TREAT allows you to change the declared type of the expr argument. This function comes in handy when you have a subtype that is more specific to your data and you want to convert the parent type to the more

orahome 20/09/2018 Oracle Built-in SQL Functions Read more
  • « Previous

Recent Posts

  • Find the size of directories
  • How to Solve IP address conflict on Unix or Windows
  • Delete files older than 30 days in Linux
  • Excel Countif in Oracle SQL
  • Shotcut stuck rendering at certain percentage

Categories

  • Access Functions
  • Affiliate Marketing
  • Articles
  • Book Reviews
    • MySQL Book Reviews
    • Oracle Book Reviews
    • Other Book Reviews
    • PHP Book Reviews
    • Web Marketing Book Reviews
  • Computer Book Releases
  • Computer Magazines
  • Computer Products
  • CSS Tips
  • Excel Functions
  • Javascript Code
  • MySQL Code
  • Oracle Built-in SQL Functions
  • Oracle DBA
  • Oracle Error Codes
    • EXP Error Codes
    • IMP Error Codes
    • ORA Error Codes
    • PLS Error Codes
  • Oracle Forms
  • Oracle Functions
  • Oracle Procedures
  • Oracle SQL
  • PHP Code
  • SEO Tips
  • Unix Code
  • Video Editing
  • Web Hosting

Archives

  • November 2020
  • August 2020
  • June 2020
  • May 2020
  • March 2020
  • March 2019
  • September 2018

Tag Cloud

059652708X 0596100892 0596101058 0596528000 book review computer magazine exp-00079 error code IMP-00066 mysql stored procedure programming ora-00229 error code ORA-00325 ora-00957 error code ORA-01046 ora-01226 error code ORA-01317 ora-01559 error code ORA-01646 ora-01722 ora-01747 error code ORA-01844 ora-02028 error code ORA-02141 ora-02318 error code ORA-02427 ora-02818 error code ORA-03206 ora-06032 error code ORA-06314 ora-06756 error code oracle error ora-00083 oracle error ora-00447 oracle error ora-01141 oracle error ora-01471 oracle error ora-01942 oracle error ora-02233 oracle error ora-02723 oracle error ora-04033 oracle error ora-06544 oracle error pls-00356 oracle pl/sql programming oracle set PLS-00220 pls-00451 error code PLS-00566 windows vista the definitive guide

Amazon Offers

Categories

  • Oracle SQL
  • Unix Code
  • MySQL Code
  • Oracle Functions
  • PHP Code
  • Oracle DBA
  • Oracle Procedures
  • Oracle Forms
  • ORA Error Codes
  • Computer Magazines

Pages

  • ASCII Table Lookup
  • Computer Book Reviews
  • New Computer Books
  • Oracle Database 10g
  • Oracle Employers
  • Oracle Forms
  • Oracle Jobsites
  • Oracle Reports
  • Oracle White Papers
  • Top 10 Javascript Books
  • Top 10 MySQL Computer Books
  • Top 10 Oracle Computer Books
  • Top 10 PHP Computer Books
  • Top 10 Raspberry Pi Books
  • Top 10 SEO and Internet Marketing Books
  • Unix Commands Cheat Sheet
Copyright © 2021 Oracle Home.
The owner of this website, OracleHome, is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking www.oraclehome.co.uk to Amazon properties including, but not limited to, amazon.co.uk
  • Sitemap
  • Contact us
  • Privacy Policy