How to create procedure

Answer 1

create database
use database
create table tablename
in sql
in oracle database is already created u just need to do your task
create table tablename
ex:-
CREATE test;
use test;
CREATE TABLE employee
(
id int primary key,
name varchar(30),
dob datetime,
email varchar(48)
);
now your table will be create to see that use
DESC employee;

Answer 2

You question is confusing please ask it more clearly kid

Answer 3

I need to know what are the standed for create procedure

Answer 4

using Sql

Answer 5

What do you mean by procedure and btw you can edit you answers you don't have to post another one

Answer 6

thanks lot any one explain why use cursor function in procedure

Answer 7

dear all I have table which include contract no,contract active or not and cheq relevant to contracts,cheques status so I need know if contract non active cheq no need updatr as closed please help to create procedure