JubbaSmail

declare
  CURSOR x(g varchar2 ) is
  select cust_first_name,cust_last_name,cust_email,income_level from customers
  where gender=g;
  cust_row x %rowtype;
begin
   --open
   open x('F');
   --fetch (loop)
   LOOP

JubbaSmail

declare
  CURSOR x(g varchar2 ) is
  select customer_id, cust_first_name,cust_last_name,cust_email,income_level from customers
  where gender=g;
  cust_row x %rowtype;
  TYPE table_type is table of number index by BINARY_INTEGER;
  id_arr table_type;
begin
   --open
   open x('F');

JubbaSmail

declare
  CURSOR x(g varchar2 ) is
  select customer_id, cust_first_name,cust_last_name,cust_email,income_level from customers
  where gender=g;
  cust_row x %rowtype;
  TYPE table_type is table of x %rowtype index by BINARY_INTEGER;
  cust_arr table_type;
begin
   --open
   open x('F');

JubbaSmail

CREATE OR REPLACE PROCEDURE EMP_SALARY 
(
  EMP_ID IN NUMBER 
, VAL_SALARY OUT NUMBER 
) AS
x number:=10;
BEGIN
  select salary into VAL_SALARY from employees where employee_id = EMP_ID;
  VAL_SALARY := VAL_SALARY + x;
END EMP_SALARY;

JubbaSmail

CREATE OR REPLACE FUNCTION SUM_SALARY 
(
  DEP_ID IN NUMBER  
) RETURN NUMBER AS
x number;
BEGIN
  select sum(salary) into x from employees where department_id = DEP_ID;
  return x;
END;

JubbaSmail

CREATE OR REPLACE PROCEDURE GET_STUDENT_Mobile_BY_ID 
(
  std_id IN NUMBER 
, std_mobile OUT NUMBER
) AS 
BEGIN
  select mobile into std_mobile from students where ID = std_id;
END GET_STUDENT_Mobile_BY_ID;
-----------------------------------------------------
CREATE OR REPLACE PROCEDURE GET_STUDENT_NAME_BY_ID 

JubbaSmail

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

JubbaSmail

#include <windows.h>

#if define UNICODE
	#define RegOpenKeyEx RegOpenKeyExW
	#define RegSetValueEx RegSetValueExW
	#define RegDeleteValue RegDeleteValueW
#else
	#define RegOpenKeyEx RegOpenKeyExA
	#define RegSetValueEx RegSetValueExA
	#define RegDeleteValue RegDeleteValueA

JubbaSmail

#include <windows.h>

#if define UNICODE
	#define RegOpenKeyEx RegOpenKeyExW
	#define RegEnumValue RegEnumValueW
	#define RegQueryValueEx RegQueryValueExW
#else
	#define RegOpenKeyEx RegOpenKeyExA
	#define RegEnumValue RegEnumValueA
	#define RegQueryValueEx RegQueryValueExA

JubbaSmail

#include <windows.h>

#if define UNICODE
	#define RegOpenKeyEx RegOpenKeyExW
	#define RegCreateKeyEx RegCreateKeyExW
	#define RegDeleteKey RegDeleteKeyW
#else
	#define RegOpenKeyEx RegOpenKeyExA
	#define RegCreateKeyEx RegCreateKeyExA
	#define RegDeleteKey RegDeleteKeyA