i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions

4 Answers   CGI,

---

What is a system tablespace and when it is created?

0 Answers  

---

What exactly do quotation marks around the table name do?

0 Answers  

---

What is backup in Oracle?

0 Answers   MCN Solutions,

---

What is not equal to in oracle?

0 Answers  

---

Explain the use of owner option in exp command.

0 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  

---

18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>

2 Answers   Wipro,

---

Explain alias?

0 Answers  

---

What are the ways tablespaces can be managed and how do they differ?

0 Answers  

---

What are the different approaches used by Optimizer in choosing an execution plan ?

2 Answers  

---

How to retrieve data from an cursor to a record?

0 Answers  

---