jenipriya
Last Activity: Jul 17 '07, 11:42 AM
Joined: Jul 4 '07
Location:
-
jenipriya replied to Its very very urgent Please....Could you please help.plz help in solving queriesin OracleI have gone through the articles and tried answers for these queries .. But stil i have doubt and hence posted with the ans i have tried.... Could you please check and tell me where i went wrong.This is my first assignment and haven't undergone any training. thats y i seek help badly from this forum........ -
jenipriya started a topic Its very very urgent Please....Could you please help.plz help in solving queriesin OracleIts very very urgent Please....Could you please help.plz help in solving queries
Hi all... its very urgent.. please........i m a beginner in oracle.... Anyone please help me wit dese codes i hv tried... and correct the errors...
The table structures i hav
Employee (EmpID, EmpName,DeptID, DateOfJoin, Sal, Addr)
Finance (EmpID, Sal)
Club (Clubname, EmpID, Fee, DateOfJoin)
Leave (EmpID, Date)
Department (DeptID, DeptName, NoOfEmployees)
-----------------------------------------------------------------------------------------------------... -
Its urgent could u please help me to find the salary deductionsLeave a comment:
-
1. CREATE OR REPLACE TRIGGER mytrig
2. After INSERT ON Employee
3. FOR each ROW
4. BEGIN
5. IF inserting THEN
6. INSERT INTO Finance VALUES(:NEW.emp no,:NEW.sal);
7. UPDATE INTO Department SET Department.NoOf Employees = Department.NoOf Employees + 1;
8. END IF;
9. END;
Wil dis query work? plz correct if der s anythng wrong...Leave a comment:
-
Actually i m a fresher and nevr tried triggers cud u giv an example so that i can try and get back to u with the code.. the table stryctures are
Employee (EmpID, EmpName,DeptID DateOfJoin, Sal, Addr)
Finance (EmpID, Sal)
Club (Clubname, EmpID, Fee, DateOfJoin)
Leave (EmpID, Date)
Department (DeptID, DeptName, NoOfEmployees)Leave a comment:
-
Employee (EmpID, EmpName,DeptID DateOfJoin, Sal, Addr)
Finance (EmpID, Sal)
Club (Clubname, EmpID, Fee, DateOfJoin)
Leave (EmpID, Date)
Department (DeptID, DeptName, NoOfEmployees)
dis s the table structure i have...Leave a comment:
-
Could anyone help me in writing triggers? Plzz
I have an employee table which contains the fields EmpId,EmpName,D eptId,DateOfJoi n,Sal,Addr
how to write a trigger for this table such that
whenever a new employee is added to the employee table one row should be added in the Finance table(ID,SAL) for that employee and update Department table(DeptId,De ptName,NoOfEmpl oyees)
such that Department.NoOf Employees = Department.NoOf Employees + 1
... -
plz help me in dis query...
how to write a query to calculate the salary deduction for an employee in a given dept for a given month?
salary deduction is
sum of Clubfees(from club table) + SAL(from employee table/30 * no of leaves taken for that month (from leave table)...
in leave table only DateOfLeave column s there.. how to calculate leave taken for that month and how to use in dis query? -
Could u help me in dis? To display the no of leaves taken by an employee for a given month how to write a query?
can v giv sysdate-date of leave?Leave a comment:
-
could u please explain this bcoz i m a fresher and i don get u...Leave a comment:
-
Thanks for the code... I got it...Leave a comment:
-
Urgent............Plzzzzzz help me in dis
Hw to insert a row using %RowType attributes and how to display the noof leaves taken by an employee for a given month? -
jenipriya replied to I m a fresher in oracle plz help me in solving these queries.. plz provide tips alsoin OraclePlease tell me how to insert a row in the table using %RowType attributes in PL/SQLLeave a comment:
-
jenipriya started a topic I m a fresher in oracle plz help me in solving these queries.. plz provide tips alsoin OracleI m a fresher in oracle plz help me in solving these queries.. plz provide tips also
Tables
------------
Employee (EmpID, EmpName,DeptID DateOfJoin, Sal, Addr)
Finance (EmpID, Sal)
Club (Clubname, EmpID, Fee, DateOfJoin)
Leave (EmpID, Date)
Department (DeptID, DeptName, NoOfEmployees)
Queries
---------------
5. display the salary deduction details for the employees in a given department for a given month. The salary deduction is sum ( Club fees...
No activity results to display
Leave a comment: