Answer / 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.

Answer / 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.

What are the attributes that are found in a cursor?

0 Answers  

---

Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15

2 Answers  

---

Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here

2 Answers  

---

How to select some rows from a table in oracle?

0 Answers  

---

What are the tools for Oracle ?

0 Answers   Infosys,

---

What is difference between cartesian join and cross join?

0 Answers  

---

What is Hash Index?

1 Answers  

---

What is Trigger in Oracle?

0 Answers   MCN Solutions,

---

What are virtual columns?

2 Answers   TCS,

---

Explain the use of rows option in exp command.

0 Answers  

---

What are the numeric comparison operations?

0 Answers  

---

List out the difference between commit, rollback, and savepoint?

0 Answers  

---