What is difference between mysql and postgresql?
No Answer is Posted For this Question
Be the First to Post Answer
How to find last day of the month in sql query
How do I find duplicates in sql?
How can you create an empty table from an existing table?
What is snowflake sql?
Dear All, Question for this Week Find out possible error(s) (either at compile time or at runtime) in the following PL/SQL block. State the reason(s) and correct the errors. Declare Cursor C1 is select ename, sal, comm from emp; Begin For i in C1 Loop If i.comm between 299 and 999 then Dbms_output.put_line(i.Ename || ‘ ** Good Commission’); Elsif i.comm > 999 then Dbms_output.put_line(i.Empno || ‘ ** Very Good Commission’); close C1; Else Dbms_output.put_line(i.Ename || ‘ ** ’ ||nvl(i.comm,‘O’)); End if; End Loop; End;
How do I run pl sql in sql developer?
If we update a complex view, is base table will get update ?
2 Answers Ardee Technologies, HCL,
What is the trigger in sql?
how can create data base link for tow servers (scott schema) give examples plz
Which constraints we can use while creating database in sql?
Explain the methods used to protect source code of pl/sql.
what is check constraint? : Sql dba