Answer Posted / t.murali krishna

Types of joins:
1. Inner join
equi join
non equi join
selfjoin
2.Outer join
left outer
right outer
full outer(from 9i)
3.Natural join(from 9i)
4.cross join

When do you get a .pll extension in oracle?

1189

---

Can we store pictures in the database and if so, how it can be done?

1089

---

How to create additional tablespaces for an new database?

1075

---

Difference between varchar and varchar2 data types?

1257

---

How to change user password in oracle?

1092

---

how to make an oracle object

2393

---

How to change program global area (pga) in oracle?

1145

---

What are advantages of dateset in datastage?

2305

---

In oracle there is column command, how will you explain that?

1135

---

How to loop through data rows in the implicit cursor?

1117

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1746

---

How to convert character types to numeric types?

1191

---

How to get a create statement for an existing table?

1011

---

Explain an index segment?

1158

---

How to create a new table in oracle?

1230

---