Interested to Buy Any Domain ? << Click Here >> for more details...
what is try_catch block in procedure
- 0 Answers
- 1808 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;
What is the difference between explicit and implicit cursors in oracle?
how to create a table index in mysql? : Sql dba
What are the types of functions in sql?
how to get enames with comma seperated values by deptwise on emp table?
What is a schema? How is it useful in sql servers?
how mysql optimizes distinct? : Sql dba
What is trigger in flip flop?
What is ttitle and btitle?
What has stored procedures in sql?
what is the sql query to display current date? : Sql dba
Explain what is a view?
-
Oracle (3253) - 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)
