An Oracle Spin by Alex Lima

Sharing Tips & Tricks from my Database Experience

Menu Skip to content
  • Home
  • GoldenGate
  • General DBA
  • Oracle White Papers
  • Disclosure
  • About

Tag: numeric

July 16, 2010February 9, 2016 Alex Lima

How to find row that has non-numeric value in a character column?

Follow Me

  • Twitter
  • LinkedIn
  • YouTube

Categories

  • 18c (2)
  • 19c (3)
  • AIX (1)
  • Archivelog (3)
  • Auditing (2)
  • AWR (10)
  • Backup (4)
  • Backup & Recovery (35)
  • Batch (1)
  • Big Data (1)
  • Built-in stored procedures (1)
  • Connections (1)
  • Control file (3)
  • Cursor (3)
  • Database (12)
  • Dataguard (3)
  • Dataguard (3)
  • Datatypes (6)
  • Date (2)
  • Docker (1)
  • exp (2)
  • Export (6)
  • Flashback (5)
  • General DBA (265)
  • Globalization (6)
  • GoldenGate (24)
  • Grant (5)
  • Initialization (4)
  • install (2)
  • Internal (4)
  • JDBC (5)
  • Jobs (4)
  • Linux (2)
  • Listener (4)
  • LOB (2)
  • Lock (3)
  • Log Miner (1)
  • mac (2)
  • Microservices (9)
  • Monitor (1)
  • MySQL (2)
  • NetApp for Oracle (2)
  • OCI (2)
  • OEM – Grid Control (5)
  • OpenWorld 2010 (3)
  • ORA Errors (3)
  • Oracle RAC (4)
  • oradebug (9)
  • OS (3)
  • osql (1)
  • Parameters (8)
  • partition (1)
  • Password (3)
  • performance (1)
  • PL/SQL (4)
  • postgres (1)
  • Power Shell (2)
  • Primavera (3)
  • Profiler (1)
  • Project Management (3)
  • RMAN (36)
  • role (3)
  • Scheduler (9)
  • Scripts (26)
  • Security (7)
  • sga (4)
  • Shared Pool (3)
  • Shell (15)
  • snapshot (1)
  • SQL – DDL (4)
  • SQL Developer (2)
  • SQL Server (69)
  • SQL*Plus (17)
  • SQLcl (2)
  • startup (4)
  • Statistics (14)
  • Statspack (3)
  • Table (3)
  • tablespace (2)
  • trace (32)
  • Transaction (5)
  • Tuning (35)
  • Tuning (6)
  • Undo (1)
  • Unix (33)
  • Upgrade (1)
  • vi (5)
  • windows (9)

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 500 other followers

Twitter Updates

  • "@OracleDatabase 21c and APEX service deliver its 'magnum opus.'" Read the new analysis from @englishMDP and… twitter.com/i/web/status/1… 1 hour ago
  • Good for her, Woman Sues Southwest, Says She Was Kicked Off Flight for Sipping Water businessinsider.com/southwest-airl… 8 hours ago
  • New version for #sqldeveloper folks, don't forget to upgrade. @thatjeffsmith #GoldenGate #OracleDatabase… twitter.com/i/web/status/1… 9 hours ago
  • video.foxnews.com/v/629260818700… 17 hours ago
  • RT @MLuttrellTX: What happened to the Alvarez family is heartbreaking. The idea that someone gets to sleep in their own bed after being arr… 22 hours ago
Follow @aoflima

Recent Posts

  • SQL Developer / SQLcl “info+” command
  • Demo – How to Quick Automate GoldenGate Microservices Replication
  • Demo – GoldenGate Migration Utility
  • My Top 5 favorite GoldenGate 21c New Features
  • Create GoldenGate 21c Microservices Docker Container under 5 min

Top Posts

  • How to stop a job scheduled in DBMS_SCHEDULER?
  • How to find the NLS_LANG to set for a database?
  • How to find jobs currently running or history about the jobs?
  • How to grant SELECT access to v$session to other users?
  • How to see current utilization of processes/sessions and max utilization?
  • How to delete/reset a parameter in spfile using ALTER SYSTEM?
  • How to lock/unlock statistics on a table?
  • Oracle Release Roadmap
  • How to extract the DB LINKS DDL with the password
  • ALTER DATABASE BEGIN/END BACKUP
Blog at WordPress.com.
  • Follow Following
    • An Oracle Spin by Alex Lima
      • Join 500 other followers
    • Already have a WordPress.com account? Log in now.
    • An Oracle Spin by Alex Lima
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar