what is switch column,colums cost in oracle?
Explain the concept of normalization.
What are the ddl commands?
If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?
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;
in a package one procedure is wrong package shows valid or not
What is compound trigger?
what are Dynamic SQL statements?
define sql delete statement ? : Sql dba
Is it possible to pass parameters to triggers?
Types of joins?
How do you pronounce sql?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba