Answer Posted / sachin

create /alter proc nameof procedure
as/is
beging
statment
EXCEPTION
end

What are stuff and replace function?

1141

---

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

1093

---

What is the most important ddl statements in sql are?

1042

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1133

---

What is java sql connection?

1120

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1641

---

What are sql built in functions?

978

---

What is a trigger in sql?

1234

---

Does truncate table reset auto increment?

1049

---

What are the types of functions in sql?

1064

---

Can we create table in function?

1017

---

Is sqlite thread safe?

1102

---

What are tables in sql?

1115

---

i have some prob lem to tell me about my self in interview first round ...

2215

---

Can a foreign key have a different name?

995

---