Blog Archives

Northwind Database Creation Script for SQL Server and Oracle

T SQL Date format convert function

Northwind is my favorite database for trying out sample T-SQL scripts because of its simplicity. Here is the full script you can just copy/paste and run in SSMS (for sql server) or SQL Developer (for oracle) to create Northwind database

Tagged with: , ,
Posted in SQL Server, T-SQL Tips

Oracle SQL Developer cant find JDK JAVA.exe

This week I had fun with Oracle realm … I never though that it would be so much pain stepping out of MS world.. where everything happens at click of button… But any ways I though I would share few

Tagged with:
Posted in Tips