Oracle SQLDeveloper and PostgreSQL

In order to use SQLDeveloper to connect to a PostgreSQL database you need the following:

  1. Download PostgreSQL’s JDBC driver from https://jdbc.postgresql.org/download.html
  2. In SQLDeveloper go Tools->Preferences->Database->Third Party JDBC Driver and add the path to the downloaded jar file
  3. Creating a new Connection it is enough to select PostgreSQL tab instead of Oracle

One more tip:

In case the database name differ’s from the username used to connect (ie username: root and database: test) , in the Hostname field add the following string hostname:port/dbname? 

Watch out, the question mark (?) at the end is mandatory to make it work 🙂

Posted in database, postgresql | Comments Off on Oracle SQLDeveloper and PostgreSQL

Oracle Utilities 1.X (Lodestar): User last access query

Utility query to find a specific user’s access date in Oracle Utilities (Lodestar)

SELECT DISTINCT U.USERID, 
MAX(A.EVENTTIME) OVER (PARTITION BY U.USERID) AS LASTACCESS
FROM LSUSERACTIVITY A 
JOIN LSUSER U ON U.USERID = A.USERID AND U.STATUS = 0
ORDER BY LASTACCESS DESC;
Posted in lodestar, oracle, utilities | Comments Off on Oracle Utilities 1.X (Lodestar): User last access query

Oracle Utilities 1.X (Lodestar): Query to search a string in rate forms

Utility query to search any text within Lodestar’s rate forms

SELECT r.*
FROM rateformvertext t
JOIN rateformversion v ON T.UIDRATEFORMVERSION = v.uidrateformversion
JOIN rateform r on r.uidrateform = v.uidrateform
WHERE dbms_lob.instr(t.rftext,utl_raw.cast_to_raw('STRING_TO_SEARCH'))>0;
Posted in oracle | Tagged , , , | Comments Off on Oracle Utilities 1.X (Lodestar): Query to search a string in rate forms

Apple Macbook: Resetting PRAM and NVRAM

It can happen that your Macbook starts acting odd… It doesn’t detect the airport card, it doesn’t notify the battery status properly or it simply doesn’t boot at all. Well, then may be you need to reset the PRAM and NVRAM.

To reset PRAM and NVRAM follow these instructions:

  1. Shutdown the computer
  2. Locate the following keys on the keyboard: Command, Option (Alt) , P, and R. You will need to hold these keys down simultaneously in step 4.
  3. Turn on the computer.
  4. Press and hold the Command-Option(Alt)-P-R keys. You must press this key combination before the gray screen appears.
  5. Hold the keys down until the computer restarts and you hear the startup sound for the second time.
  6. Release the keys.

Your computer’s PRAM and the NVRAM are reset to the default values. The clock settings may be reset to a default date on some models.

Now you should see your wireless airport card again.

Posted in macosx | Tagged | Comments Off on Apple Macbook: Resetting PRAM and NVRAM