In order to use SQLDeveloper to connect to a PostgreSQL database you need the following:
- Download PostgreSQL’s JDBC driver from https://jdbc.postgresql.org/download.html
- In SQLDeveloper go Tools->Preferences->Database->Third Party JDBC Driver and add the path to the downloaded jar file
- 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 🙂
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;
Utility query to search any text within Lodestar’s rate forms
FROM rateformvertext t
JOIN rateformversion v ON T.UIDRATEFORMVERSION = v.uidrateformversion
JOIN rateform r on r.uidrateform = v.uidrateform
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:
- Shutdown the computer
- 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.
- Turn on the computer.
- Press and hold the Command-Option(Alt)-P-R keys. You must press this key combination before the gray screen appears.
- Hold the keys down until the computer restarts and you hear the startup sound for the second time.
- 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