Often students from the initial semester ask me how do we store our data in our programming projects? When students join university to learn about computer science and technology they are usually taught programming first in courses like introduction to…
A few days back I came across a requirement to fetch the records from the table having all lowercase letters. This was an interesting scenario. The SQL Server database by default is set for case-insensitive. But, I need to do…
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…
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…
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> the easy way.