Blog - Tech / Database / Oracle

How to split comma separated string and pass to IN clause of select statement

Sep 18 at 1:57pm | 0 comments

Using TNSPING with host and port

Jun 18 at 8:06am | 0 comments

What privilege to view oracle package body

Jun 12 at 8:10am | 0 comments

How to find the privileges and roles granted to a user in Oracle

Feb 25 at 2:39pm | 0 comments

How to pass host, port, SID/Service name to connect to a oracle database

Feb 25 at 1:49pm | 0 comments

Copy Sql Navigator Connections to a new pc

Aug 01 at 7:36am | 0 comments

Find invalid objects in your databases

Jul 19 at 6:58am | 0 comments

ORA-00942: table or view does not exist for a procedure

Nov 20 at 2:56pm | 0 comments

PL/SQL: ORA-00942: table or view does not exist

ORACLE/PLSQL: TEST A STRING FOR A NUMERIC VALUE

Jun 26 at 7:45am | 0 comments

Create an MsAccess Oracle like DUAL table

Sep 18 at 10:59am | 0 comments

Had a need to replicate some logic used in Oracle into an Access db.  The oracle DUAL table is very handy.  I found this article on creating a hidden dual table.  It looked interesting but I didn't fully vet it.