Pages

Monday 30 September 2013

Online Solution for Oracle PL/SQL, C, C++, VBScript, JavaScript, C#, .Net and many more: Creating an inilne view in SQL,PL/SQL

Online Solution for Oracle PL/SQL, C, C++, VBScript, JavaScript, C#, .Net and many more: Creating an inilne view in SQL,PL/SQL: Here is an example of an inline view SQL. Lets take for example three tables/ 1. tbl_withdrawdeposit     memb_id  -- reference to p_k t...

Online Solution for Oracle PL/SQL, C, C++, VBScript, JavaScript, C#, .Net and many more: Add dynamically values to a combo list in Oracle D...

Online Solution for Oracle PL/SQL, C, C++, VBScript, JavaScript, C#, .Net and many more: Add dynamically values to a combo list in Oracle D...: -- first  method using creategroupfromquery function creating a recordgroup dynamically declare myrec RECORDGROUP; begin if not id_null...

Online Solution for Oracle PL/SQL, C, C++, VBScript, JavaScript, C#, .Net and many more: Retrieve Data from Oracle Database with ADODB usin...

Online Solution for Oracle PL/SQL, C, C++, VBScript, JavaScript, C#, .Net and many more: Retrieve Data from Oracle Database with ADODB usin...: <!DOCTYPE html> <html> <body> <% set con=Server.CreateObject("ADODB.Connection") con.Open("Provider=MSD...

Wednesday 25 September 2013

Online Solution for Oracle PL/SQL, C, C++, VBScript, JavaScript, C#, .Net and many more: How to create a dynamic combolist and add data fro...

Online Solution for Oracle PL/SQL, C, C++, VBScript, JavaScript, C#, .Net and many more: How to create a dynamic combolist and add data fro...: <html> <head> <script> function myFunction() { var con = new ActiveXObject('ADODB.Connection'); var rs = ne...

Online Solution for Oracle PL/SQL, C, C++, VBScript, JavaScript, C#, .Net and many more: Oracle PL/SQL cursor example

Online Solution for Oracle PL/SQL, C, C++, VBScript, JavaScript, C#, .Net and many more: Oracle PL/SQL cursor example: --A Procedure ProcCur is created create or replace procedure ProcCur is --A cursor is declared selecting 2 fields from employee_master ...

Online Solution for Oracle PL/SQL, C, C++, VBScript, JavaScript, C#, .Net and many more: Using case statement in sql query on SQLServer dat...

Online Solution for Oracle PL/SQL, C, C++, VBScript, JavaScript, C#, .Net and many more: Using case statement in sql query on SQLServer dat...: Say there is a table employee_master and we are going to use 5 fields emp_code, emp_name, emp_sex, emp_grade and emp_category last thre...

Online Solution for Oracle PL/SQL, C, C++, VBScript, JavaScript, C#, .Net and many more: How to extract day, month and year from a date fie...

Online Solution for Oracle PL/SQL, C, C++, VBScript, JavaScript, C#, .Net and many more: How to extract day, month and year from a date fie...: Here is a method to extract day, month and year from date field in sql server sql database. Say their is a table named employee_attendanc...

Online Solution for Oracle PL/SQL, C, C++, VBScript, JavaScript, C#, .Net and many more: How to use Split Function in Visual Basic 6.0

Online Solution for Oracle PL/SQL, C, C++, VBScript, JavaScript, C#, .Net and many more: How to use Split Function in Visual Basic 6.0: Split function in VB 6.0 actually splits a string based on delimiter provided and returns it into an array. Suppose there is a string li...

Online Solution for Oracle PL/SQL, C, C++, VBScript, JavaScript, C#, .Net and many more: Reading an excel file using Microsoft excel object...

Online Solution for Oracle PL/SQL, C, C++, VBScript, JavaScript, C#, .Net and many more: Reading an excel file using Microsoft excel object...: option explicit Private exc as Object Private wb as Object Private ws as Object Private sub ImportExcelData(excelFileName as String) ...

Online Solution for Oracle PL/SQL, C, C++, VBScript, JavaScript, C#, .Net and many more: How to load a picture from resource file (.res) in...

Online Solution for Oracle PL/SQL, C, C++, VBScript, JavaScript, C#, .Net and many more: How to load a picture from resource file (.res) in...: option explicit Private Declare Sub CopyMemory Lib "kernel32.dll" Alias "RtlMoveMemory" (ByRef Destination As Any, ByR...