SignalR & Oracle DB Change Notification [Part 2 of 2]
What is Oracle change Notification ? The Oracle Data Provider for .NET provides a notification…
![SignalR & Oracle DB Change Notification [Part 2 of 2]](https://haneefputtur.com/wp-content/uploads/2018/02/out2-1024x566.jpg)
Posted inOracle
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…
Posted inOracle
Oracle pl/sql dynamic query with IN paramters
Issue: Sending dynamic paramter to oracle pl/sql. Example : you will pass a paramter of…
Installing 64 Bit Oracle Client : Windows 10 – 64 Bit
Scenario : You want to install Oracle Client and ODBC driver in Windows 10 -…
Posted inOracle
Oracle PL/SQL to Send ARABIC Emails with SMTP AUTHENTICATED Server UTL_SMTP
declare TO_EMAIL VARCHAR2(255) := 'toemailaddress'; FROM_EMAIL VARCHAR2(255) := 'fromemailaddress'; MAIL_SUBJECT VARCHAR2(255) := 'Test Subject'; FROM_NAME…
Install Oracle DB Express and Connect to ASP.Net MVC C# Using Dapper and ODP.net
Tools Used : Oracle DB Express Toad for Oracle ( To explore database-- You can…
Posted inOracle
How to Check / Kill Oracle Live Sessions
Step 1 : Run following script to display active sessions; SELECT O.OBJECT_NAME, S.SID, S.SERIAL#, P.SPID,…
How to Clean up names and split names in Excel as First , Middle and Last Name
Scenario : You have a excel file with one column which is full name. It…
AJAX Query to fill Select List MVC , C# asp.net
This is Proof of Concept for Querying data using AJAX and filling the drop down…
Installing Oracle ODBC Driver to Windows 2012 Server R2
Step1: Download 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio…