Month: May 2015
ASP .Net + Oracle Example for Beginner: Get the Resultset Using SELECT Statement (and Not Stored Procedure)
When I started working on a .Net application which uses Oracle database, I had a very simple requirement. I need to execute SELECT statement, get the resultset into the .Net and show the data in a grid view. Having a SQL Server background, I thought a quick search in google would provide me an example…
How to Edit NLS Parameters in Toad for Oracle and Oracle SQL Developer?
When I found that changing the NLS parameters in the Oracle will make the search query case insensitive, I tried to find a way to change the NLS parameters in Toad for Oracle and Oracle SQL Developer in order to change it every time I login to Oracle. Changing the NLS parameter in Oracle SQL…