I have a table where there are 5 columns let say a,b,c,d,tran_date. I want to generate aquery to find out the minimum tran_date for everya,b,c,d in the table.
I need to compare and match the longest match of two strings in two different tables and update one values if there is a closest match.
---------- User ---------- user_ID(pk) UserEmail ---------- Project_Account ---------- actno actname projno projname
Can you tell me how to update multiple rows in oracle as when I fired the update statement it gave me the following开发者_开发问答 error
To test and display the result of some functions of my library, I am creating a set of handy functions.