Oracle Blog

Oracle Blog

Oracle SQL, PL/SQL and APEX

  • About Me

Category: DBA

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

How to update user’s password with the same password

Posted on 19/12/201805/07/2023 by admin

If you don’t know the user’s password that had been saved in TOAD or SQL DEVELOPER and will expire soon. You can update as it is. In Oracle […]

More Details
Posted in DBALeave a Comment on How to update user’s password with the same password

JOB_QUEUE_PROCESSES parameter

Posted on 13/12/201805/02/2020 by admin

In our company we came across duplicative jobs that have been executed by the system. After an investigation, we find out that, these jobs were run from our […]

More Details
Posted in DBALeave a Comment on JOB_QUEUE_PROCESSES parameter

Posts navigation

Newer posts

Recent Posts

  • How to use dynamic SQL with DBMS_SQL
  • ORA-01704 string literal too long
  • How to fix cardinality misestimate?
  • CUME_DIST function
  • FOR UPDATE vs FOR UPDATE SKIP LOCKED

Recent Comments

  • admin on How to generate, parse and use JSON data
  • Johann on How to generate, parse and use JSON data
  • 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

Categories

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

Flag Counter

© Copyright 2023, Çağlar Polat