Oracle PL/SQL to check whether variable is text or number

Issue : sometime its very important to check a variable is number or text in order to avoid any exception. Assume your variable is xyz SELECT DECODE(TRIM(TRANSLATE(xyz,’0123456789′,’  ‘)), NULL, ‘number’,’characters’) FROM DUAL; SELECT DECODE(TRIM(TRANSLATE(’12s3456′,’0123456789′,’ ‘)), NULL, ‘number’,’characters’) FROM DUAL; Returns : characters SELECT DECODE(TRIM(TRANSLATE(‘1233456′,’0123456789′,’ ‘)), NULL, ‘number’,’characters’) FROM DUAL; Returns : number What is Translate Function: For… Read More »

Oracle pl/sql dynamic query with IN paramters

Issue: Sending dynamic paramter to oracle pl/sql. Example : you will pass a paramter of employee names to the procedure and you want to dynamically construct the SQL query. Parameter Passed : v_emp   Value Passed : v_emp = ‘haneef,ganesh,rajesh,minaal’   This query will not work:   SELECT emp_id, emp_name from, FROM EMP_TABLE WHERE emp_name… Read More »

WordPress Installation – Local PC/Laptop

If you want to install WordPress locally in your pc follow these guidelines. Presentation Please refer : WordPress Installation in Local machine for Dummies By Haneef Puttur from Haneef Puttur Refer the Video Tutorial here Links for Downloading : UWAMP WordPress  

Domain Name Basics – Explained

I have created a short video which will give complete basic information about domain name registration and its basics. Feel free to download the presentation from the below link : Domain registration – Basics for Dummies by Haneef Puttur from Haneef Puttur   Youtube Video    Feel free to ask your questions .

Installing 64 Bit Oracle Client : Windows 10 – 64 Bit

Scenario : You want to install Oracle Client and ODBC driver in Windows 10 – 64 Bit Files Required : Oracle Instant Client Basic : Instant Client Package – ODBC : Step 1 : Download Above 2 Packages. Step 2: Copy all the contents to a single folder and name the folder as “oracle”… Read More »

Error Could not load file or assembly ‘System.Net. ASP.NET MVC C#

Error : Could not load file or assembly ‘System.Net.Http.Formatting, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35’ or one of its dependencies. The system cannot find the file specified. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.… Read More »

Rotativa :: HTTP Error 401.2 – Unauthorized You are not authorized to view this page

Scenario Using Rotativa as PDF convertor in ASP.NET MVC C# with Active directory login authentication Problem HTTP Error 401.2 – Unauthorized You are not authorized to view this page due to invalid authentication headers Cause : If you use Rotativa.ActionAsPDF it will not pass the header values related to authentication to the new page. So… Read More »