what are the authentication modes in sql server? How can it be changed? : Sql dba
No Answer is Posted For this Question
Be the First to Post Answer
What are the pre requisites?
What does trigger mean in slang?
What is a boolean in sql?
Wat is SGA ?
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 run sql*plus commands that are stored in a local file?
What is sql injection owasp?
What is Difference between StoredProcedure and function?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
Explain the usage of WHERE CURRENT OF clause in cursors ?
How does sql developer connect to oracle database?
How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?