How to change expired password in Oracle?
In Oracle when the password is expired you will get the following error: ORA-28001: the password has expired This is because the password has reached 180 Default limit for a Password lifetime. Solutions: 1. Connect to the database using sys user ...
Converting Oracle DATE types and PHP/Unix Timestamps
If you need to convert between Oracle date and PHP/Unix timestamp then you might need to implement two functions in Oracle. The following two Oracle functions implement this for DATE types. To convert a UNIX timestamp into an Oracle DATE type: CREA ...
Working with Dates and Times in Oracle and PHP
Both PHP and Oracle provide functionality manipulating dates and times. Which to use and when? If you're new to PHP or Oracle, working out how to handle dates efficiently can be tricky. You may have strategies, which you've applied successfully on o ...
Change password in Oracle SQL Developer
To change password in Oracle SQL Developer you can just right click on connection and click the Reset Password option. Alternatively, you can run the following query to update your password: alter user <username> identified by <newpassword& ...
Allowing Oracle ports in Windows Firewall
If you plan to install Oracle Database XE onto a computer running Windows Firewall, which was first introduced in Windows XP Service Pack 2 and Windows Server 2003 Service Pack 1, and then connect to it from another computer, check that the firewall ...
Install Oracle XE 11g on Windows 64-bit
Here’s the Oracle Database 11g Express Edition step-by-step installation on Windows 7 64-bit. Please bear in mind Oracle provides only 32-bit version of Oracle XE. When you download the software from Oracle, you’ll need an account and you’ll need ...