What is the source code of a program?
No Answer is Posted For this Question
Be the First to Post Answer
What is the order of sql select?
how to enter numeric values as hex numbers? : Sql dba
What does sign mean sql?
What is primary key sql?
Easy way to convert tableau "IF - ELSEIF" statements to Netezza "CASE" statements.
What is sqlerrd?
What is the plv (pl/vision) package offers?
What is %type in sql?
check whether all the emp numbers are indeed unique.
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;
Can we rename a column in the output of sql query?
Why use subqueries instead of joins?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)