You're building a new application. So you need somewhere to store your data. It's time to create a table in your database! In this post you'll find out how to: create new tables, change (alter) existing tables, and remove (drop) a table
The weekend is over. You’re back at work. You login to the database to start coding. Only to be hit with: Gaaaaaahh! Not again. It’s time for the bi-annual trip to the DBA to get them to change the password. It’d be kinda nice to avoid this and use the same password forever. But how? Database User Profiles When you create a database user it has a profile. Which, by default, is the “DEFAULT” profile. This defines many things. Such as CPU, I/O and memory limits (though we...
The weekend. It’s the time that, hopefully, you get to leave your work behind. And, of course, those days that throw a spanner in your “next business day” calculations. In this post we'll find out how to: Get the next working day, stopping by to look at to_char format masks along the way. Add N working days to a date and do this in SQL. Find the working days between two dates and the SQL version. Deal with public holidays and other non-working days.
Indexes. They're one of the most powerful and misunderstood aspects of SQL performance. In this post we'll look at the purpose of an index, how to create and choose choose your index type. Then finish with a discussion of how to decide what to index and how to see if it's useful.