Answer Posted / parifs

1. 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.

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1791

---

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

2920

---

What is memory advisor in Oracle?

1083

---

Explain an exception?

1005

---

What is a static data dictionary in oracle?

1121

---

What are the built-in functions used for sending Parameters to forms ?

3392

---

What is the difference between a user and a schema in oracle?

1042

---

Explain what are the different type of segments?

973

---

How do you find current date and time in oracle?

1058

---

How to assign query results to variables?

1057

---

Explain a data segment?

1075

---

What is the difference between I and G in Oracle?

1104

---

Can a parameter be passed to a cursor?

1134

---

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1869

---

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2561

---