Answer Posted / suresh boddu

Control Panel>>Admin Tools>>Data Services (ODBC)>>

2. From ODBC Data Source Administrator dialog, select
requires DSN type
(User DSN, System DSN, File DSN). From the selected DSN,
click ?Add? button and select the required driver and
click ?Finish? button.

3. From ODBC Text Set up enter the Data Source Name and
Description.
Select the DB and click Ok button.

4. DSN is created.

How to define a record variable to store a table row?

1002

---

Explain drop constraint oracle?

989

---

What is oracle thin client?

973

---

What is enter substitution variable in oracle?

982

---

What are set operators?

1029

---

What is the recommended interval at which to run statspack snapshots, and why?

2860

---

What is connection pooling in oracle?

911

---

What are the oracle differences between nvl and coalesce

1066

---

How to create lov dynamically at runtime & attach to text field?

1097

---

How to rename an index?

995

---

Can we write insert statement in function in oracle?

1026

---

What are transaction isolation levels supported by oracle?

994

---

What is a system tablespace and when it is created?

918

---

Is the After report trigger fired if the report execution fails ?

2877

---

What to do if the startbd.bat failed to start the xe instance?

1015

---