Answer Posted / swapna

Synonyms are used to provide alternate name for a table
permanently.

What is a table in oracle?

975

---

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2353

---

What is an oracle recycle bin?

1007

---

Can a formula column be obtained through a select statement ?

2317

---

State the difference between a primary key and foreign key?

933

---

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'));

1688

---

How to convert characters to dates in oracle?

1091

---

Explain the importance of .pll extension in oracle?

1004

---

can u plz provide me oca sql dumps please i need them

1945

---

What is the data type of dual table?

991

---

Can we use bind variables in oracle stored procedure?

948

---

How to load data through external tables?

1135

---

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1043

---

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1998

---

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1018

---