ORA-28000: the account is locked - PeopleSoft
Hey everyone, Just a small PeopleSoft issue I ran into while running an SQR: For some reason the sysadm account had been locked, thankfully there’s a fairly easy fix:…
Read postTagged: oracle
Installing SQL Developer on Ubuntu - make-sqldeveloper-package chmod: missing operand after `755′
Hey everyone, I was following a guide while trying to install SQL Developer on Ubuntu, however I ran into the following error: make-sqldeveloper-package chmod:…
Read postView Last Query Executed - Oracle
Hey all, Just a quick post on how to view recent queries run into an Oracle database: Cheers
Read postOracle - Number of Weekdays Between Two Dates
Hey everyone, Just a quick post on how to select the number of weekdays between two dates:
Read postSending Email - PL/SQL
A quick post on how to send an email with PL/SQL. There’s a LOT of documentation available at the following link: http://www.orafaq.com/wiki/Send_mail_from_PL/SQL
Read postReserved Words - Oracle
Just a quick post on how to check if a word is reserved using the v$reserved_words: Alernatively you can specify the word, i.e. to check if online is a reserved word,…
Read postSleep Function Within PeopleCode - PeopleSoft
While at work today I discovered that there doesn’t appear to be any built in functionality to allow for a delay to be implemented within PeopleCode. Thankfully there…
Read post