Answer Posted / bipin

sql-server

inner join
outer join
left outer join
right outer join
full outer join
cross join


oracle sql

inner join
outer join
left outer join
right outer join
full outer join
cross join
natural join

How does pl sql work?

963

---

What does pl sql stand for?

1112

---

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

2163

---

What's the procedure?

929

---

How do I run a pl sql program?

1128

---

What is difference between rank () row_number () and dense_rank () in sql?

1101

---

What are the different set operators available in sql?

1026

---

Explain correlated query work?

1054

---

What port does sql server use?

1061

---

Does normalization improve performance?

1038

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

960

---

What is aggregate function in sql?

1037

---

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

990

---

What is rowtype?

1019

---

What is dense_rank?

935

---