thanks for the clarificaiton

Could we use something like this ??

SELECT 'ALTER TABLE ' +

t.Table_Name +

...

Would something like this work for you

Select Concat ( firstName,LastName) OR Select firstName|| ' ' || LastName

Into A.Name

FRom Table A A Inner JOIN TableB B...

The tables are

(

empno NUMBER(5) NOT NULL,

ename VARCHAR2(15) NOT NULL,

job VARCHAR2(10),

mgr NUMBER(4),

hiredate DATE DEFAULT (sysdate),

...

sorry about the late response

this is the package i created to calculate net pay for a user and get an error as ORA-01422: exact fetch returns more than...

Inserting is easy its the cndtion check thats getting me

A Cursor could do it as well but i just dont know how we can loop thru the salgrade table and connect it to thtree tables, after that the insert...

can you please direct me to where i can find an example

can a simple block do it as well rather than a procedure ?

sorry about the incomplete post here are rest of the tables and an insert statement

CREATE TABLE deductions (

name nvarchar(3) ,

grd_min decimal (9,2),

grd_maX decimal (9,2) )

CREATE TABLE...

This is what i am trying to do

a store procedure that will insert rows to the user deduction table. Salary grade is determined by checking the salary grade table to...

i can do that when i am on my SSMS but i have to send out a script to the client, is there any way i can turn the indexes...

Thanks again for the clarification this is what i tried

IF EXISTS(SELECT * from A where where AID ='4')

Begin

Print...

Well i am not getting it then if u can explain ti that would be awesome this is what i am trying to accomplish

Insert Into values ( 1,2,...

I think that would be impossible ( what i asked for ) only scalar variables are allowed in an insert and no subqueries as i have to enter the query...