what is online transaction processing (oltp)? : Sql dba
No Answer is Posted For this Question
Be the First to Post Answer
What is the function that is used to transfer a pl/sql table log to a database table?
Which constraints we can use while creating database in sql?
how do you know the version of your mysql server? : Sql dba
Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?
What is rownum in sql?
difference between SQL and C
1 Answers Indus Software Technologies,
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;
How do you drop a trigger?
what are %TYPE and %ROWTYPE? what is the difference?
7 Answers ICICI, Saama Tech, Sail,
How bulk collect improves performance?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
What are views in sql?
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)