Skip to content

Christoph's 2 Cents

A Backup for My Brain!

  • About
  • Fun Stuff
  • OCI Newsletter

Oracle Tools

Oracle Application Express (Apex) Oracle Developement Oracle Tools PL/SQL 

SQL Developer SSH connection

April 21, 2016 cruepprich cloud, ssh

If you have to access databases that can only be reached through SSH connections, you can configure SQL Developer (4.1)

Read more
Oracle Application Express (Apex) Oracle Developement Oracle Performance Oracle Tools PL/SQL 

SQLd360 v3 now available, new features and (hopefully) less bugs!

February 27, 2015 cruepprich

SQLd360 v3 now available, new features and (hopefully) less bugs!.

Read more
Oracle Developement Oracle Performance Oracle Tools PL/SQL 

Meet “edb360”: a free tool that provides a 360-degree view of an Oracle database

February 20, 2014 cruepprich optimization, oracle, performance, plsql, tuning

Meet "edb360": a free tool that provides a 360-degree view of an Oracle database.

Read more
Oracle Application Express (Apex) Oracle Developement Oracle Tools 

Excel Style Row Numbering in SQL

February 3, 2014 cruepprich apex, application express, connect by, hierarchy, level, oracle, pl/sql, plsql, row numbering, sql

Here is a trick to change your rownumbering (or any other sequential numbering) to the way Excel names their columns.

Read more
Linux Oracle Application Express (Apex) Oracle Developement Oracle Tools 

Configuring Apex Listener Version 2

February 21, 2013 cruepprich

“Where is the listenerConfigure page?” That seems to be a common question when people attempt to deploy the Apex Listener

Read more
Oracle Application Express (Apex) Oracle Developement Oracle Tools PL/SQL 

Apex: Accessing Tabular Form Column Values

July 26, 2012 cruepprich apex, application express, oracle, reports

I created a tabular report on a table and needed to write some custom code that does some DML based

Read more
Oracle Developement Oracle Tools PL/SQL 

QDT: Escape from Alcatraz

February 3, 2012 cruepprich datapump, oracle, pl/sql, plsql

Quick Datapump Trick Using the expdp/impdp datapump utilities on Unix/Linux can be a bit tricky when it comes to formulating

Read more
Oracle Developement Oracle Performance Oracle Tools 

An AWKward look at tkprof.

December 1, 2011 cruepprich oracle, tkprof

Reading trough a tkprof file can be a long, arduous process. How do you find the things you’re looking for,

Read more
Oracle Developement Oracle Tools 

Calculate date with same week day.

April 8, 2010 cruepprich

Move dates so that the week days remain the same.

Read more
Oracle Developement Oracle Tools 

Rlwrap, the second

April 1, 2010 cruepprich

Use a keyword file in conjunction with rlwrap to provide auto-completion functionality in SQL*Plus.

Read more
  • ← Previous
  • Next →
Oracle ACE
Copyright © 2023 Christoph's 2 Cents. All rights reserved.
Theme: ColorMag by ThemeGrill. Powered by WordPress.