Answer Posted / 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;

Which is better Oracle or MS SQL? Why?

4902

---

How to call a stored function with parameters?

1008

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4327

---

What are the differences between interval year to month and interval day to second?

1010

---

What is a lookup table in oracle?

962

---

How to export your connection information to a file?

1112

---

Describe varray?

1037

---

Can you drop an index associated with a unique or primary key constraint?

997

---

What is the difference between post-database commit and post-form commit?

1160

---

How to use "if" statements on multiple conditions?

1142

---

What are the attributes of cursor?

1031

---

What are a cluster and non-cluster index?

993

---

what is reindexing?

1647

---

IS it possible to built the oracle database without setting the kernal parameters?

2324

---

What is a tns file?

976

---