Why database should be taught before programming in universities?
Learn Database before Coding 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 fi ...
Searching Lowercase data in MS SQL Server
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 a case-sensitive search. ...
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 ...
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& ...
INSERT new rows from a result of SELECT query
There were numerous times when I needed to insert records in the table from a result of another SELECT query, or copy data from one table to another. And every time I forgot the syntax of insert...select query. So I thought I should write it somewher ...
MySQL Installation and Configuration
A step by step guide on how to install and configure MySQL on the Windows Operating System.