Which sql statement is used to delete data from a database?
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 are the different types of joins in sql?
Why do we use %rowtype & %type in plsql?
What are procedures used for?
What is db journal file?
Explain two virtual tables available at the time of database trigger execution.
what is data manipulation language? : Sql dba
What does the hierarchical profiler does?
Explain autonomous transaction.
Write a procedure to return the month and the number of developers joined in each month (cursor )
How do you pronounce sql?
What is a behavioral trigger?
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)