what is rdbms? : Sql dba
No Answer is Posted For this Question
Be the First to Post Answer
ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.
Why do we use sql constraints? Which constraints we can use while creating database in sql?
What is the difference between drop and truncate commands?
Compare sql & pl/sql
How is a process of pl/sql compiled?
What is the importance of sqlcode and sqlerrm?
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;
What is the difference between anonymous block and named block or stored procedure?
What is difference between Procedures and Functions ?
what command is used to create a table by copying the structure of another table including constraints ?
what is the difference between $message and $$message? : Sql dba
Is mariadb nosql?