![]() Related Questions Latest Answer : is it drived ? Are you sure ..I think is is Derived. ... Read Answers (1) | Asked by : Zulfiqar Ali Design a suitable database system for a bank along with 20 possible queries to the database (the quries should be such that their solution involves subquries or joins or both). Implement the database and the queries in a commercial DBMS using SQL View Question | Asked by : manesh Tags : DBMS What are the different values for :SYSTEM.MESSAGE_LEVEL and its impact? Latest Answer : There are 25 Levels of Message in an Oracle Forms.How much cretical error or message is0 -- all errors or message12...25 -- don't shows anyIf we don't wannat show any error or message to the user then we assign 25 to message level ... MERGE INTO SAS F USING (SELECT PRODID, PRODID+10 F, DESCRIP FROM PRODUCT) L ON (F.PRODID=L.PRODID) WHEN MATCHED THEN UPDATE SET F.PRODID=L.F WHEN NOT MATCHED THEN INSERT Latest Answer : I think Error lies in the following statement INSERT VALUES (L.F, L.DESCRIP) THE STATEMENT SHOULD BE LIKE THIS INSERT (F.PRODID,F.DESCRIP)VALUES(L.F,L.DESCRIP) ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||