arshadshabbir

Use BLOB datatype to store image in database

Hence answers given above fulfill the requirement only advancement in code. Try the following generic procedure pass Product Code as a parameter, also handling the exception if product_id not found in table [CODE=ORACLE] CREATE OR REPLACE PROCEDURE change_price(vProduc_id number) IS product_price NUMBER; new_price number; BEGIN SELECT price INTO product_price FROM …

I have a table in which each users can enter more than one records. My task was to find out the last amount entered by each user, i used the following query by using analytical function. you can also use it for the whole table. I have partitioned it userwise …

Try following Query using Analytical function....... [CODE]select employeeid,TransactionAmount,max_date from ( select EmployeeID, TransactionAmount,TransactionDate, max(TransactionDate) over (partition by employeeid order by employeeid) max_date from employee ) where TransactionDate = max_date order by employeeid;[/CODE]