ora-01427

Update multiple rows in oracle

Hi! Can you tell me how to update multiple rows in oracle as when I fired the update statement it gave me the following error UPDATE BI_BSELATEST_LATESTPRICESTEST SET PREVIOUS_DAY_CLOSE = (SELECT DISTINCT aa.DLYPRICE_CLOSE FROM DATAFEED_EQTY.FEED_DLYPRICE aa , ( SELECT a.sc_code , MAX(a.DLYPRICE_DAT...

Left Outer Join with subqueries?

---------- User ---------- user_ID(pk) UserEmail ---------- Project_Account ---------- actno actname projno projname ProjEmpID ProjEmpMGRID Where ProjEmpID,ProjEmpMGRID is the user_id and ProjEmpMGRID can be null. I need to look up the useremail and display the table project_account. I need to query with actNo which has duplicate valu...

Erroneous ORA-01427: single-row subquery returns more than one row

I'm getting the error [ORA-01427: single-row subquery returns more than one row] when I execute a query. I have a query structured like so: SELECT LV.PRICE, (SELECT C.MODEL_NAME FROM CARS C WHERE C.MODEL_ID = LV.MODEL_ID) as MODEL_NAME FROM LEDGER_VIEW LV WHERE LV.PRICE < 500 It's breaking on the nested select. I know the logic bot...