Answer / Pradeep Kumar Singh

To create a testing table in Oracle, you can use the SQL CREATE TABLE statement. Here is an example: CREATE TABLE test_table (id INT PRIMARY KEY, name VARCHAR2(100), age INT); This will create a table named test_table with columns id, name and age.

Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??

1 Answers   BirlaSoft,

---

Explain the types of exception?

1 Answers  

---

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

1 Answers   TCS,

---

What are various joins used while writing SUBQUERIES?

2 Answers  

---

what is unique key?

14 Answers   Amazon, Cap Gemini, Infosys, Wipro,

---

What is the difference between pre-select and pre-query?

1 Answers  

---

how to retrieve data from different tables ,place this data in different excel worksheets.

1 Answers   Gap Inc,

---

Explain the use of indexes option in exp command.

1 Answers  

---

How to write a query with an inner join in oracle?

1 Answers  

---

How to create DSN..Explain?

2 Answers   Accenture, BeBo Technologies, Infosys,

---

What is a public synonym?

1 Answers  

---

write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000

4 Answers   TCS,

---