Answer Posted / sudipta santra

Host string is the instance name of the database in the server.

when we are using sqlplus then we use to give the
username/password@<hostname>

It relate the user as a connectivity with that specified
instance.

what is meant by magic query

2175

---

Explain the use of file option in exp command.

1124

---

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

1997

---

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

1686

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2099

---

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2035

---

Respected sir, Please send me technical questions related to oracle apps..

1808

---

How do I uninstall oracle 11g?

1107

---

How to list all indexes in your schema?

1085

---

What is Reduced List of Values?

2158

---

Difference between pre-select and pre-query

1097

---

How to create a table index?

1138

---

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

1037

---

How to set a transaction to be read only in oracle?

1089

---

How to start instance with a minimal initialization parameter file?

1033

---