Answer / ali

Alias is the temporay name , where as rename is the permanent given.

RENAME:
1. RENAME OLD_TABLENAME to NEW_TABLENAME;
2. alter table table_name rename column column_name to new_columnname;

ALIAS:
1. select ename as name from table_name1 as empl1, table_name2 as empl2 where empl1.id = empl2.id;

what is the syntax of update command?

3 Answers   Semantic Space,

---

what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval

2 Answers  

---

Give syntax for SQL and ORACLE joins.

0 Answers   TCS,

---

In what script is snap$ created? In what script is the scott/tiger schema created?

0 Answers  

---

What is oracle rowcount?

0 Answers  

---

---

How to check the server version in oracle?

0 Answers  

---

Can we use bind variables in oracle stored procedure?

0 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,

---

How do I uninstall oracle 11g?

0 Answers  

---

How to define a variable to match a table column data type?

0 Answers  

---

How to recover a dropped index?

1 Answers  

---

What is data block in Oracle?

0 Answers   MCN Solutions,

---