Oracle Blog

Oracle Blog

Oracle SQL, PL/SQL and APEX

  • About Me

Category: SQL

Regular Expression

Posted on 20/12/201824/01/2019 by admin

You can use the following character classes for your regex pattern. Character Class Description [:alnum:] Alphanumeric characters [:alpha:] Alphabetic characters [:blank:] Blank Space Characters [:cntrl:] Control characters (nonprinting) […]

More Details
Posted in DBA, SQLLeave a Comment on Regular Expression

Oracle TRANSLATE function

Posted on 21/11/201820/12/2018 by admin

Oracle TRANSLATE(expression, from_string, to_string) function can replace all characters from from_string to to_string by its corresponding character. Also, the important thing is replacement is done by the order […]

More Details
Posted in SQLLeave a Comment on Oracle TRANSLATE function

Posts navigation

Newer posts

Recent Posts

  • How to fix cardinality misestimate?
  • CUME_DIST function
  • FOR UPDATE vs FOR UPDATE SKIP LOCKED
  • NVL vs COALESCE
  • How to use MULTISET UNION DISTINCT on collections

Recent Comments

  • admin on How to reorder columns of table
  • Yogendra on How to reorder columns of table
  • ENOCK OLOO on Data encryption and decryption using PL/SQL
  • Soeren Dalby on How to generate, parse and use JSON data
  • Nicolas on Print clob data with htp.prn

Archives

  • May 2023
  • January 2023
  • October 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • May 2020
  • February 2020
  • January 2020
  • December 2019
  • May 2019
  • March 2019
  • January 2019
  • December 2018
  • November 2018

Categories

  • APEX
  • DBA
  • PL/SQL
  • SQL
  • Uncategorized
  • XQuery

Flag Counter

© Copyright 2023, Çağlar Polat