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;

How to retrieve data from an cursor to a record?

1008

---

What happens if you set the sga too low in oracle?

1050

---

What is the usage of save points in oracle database?

903

---

What is a select query statement in oracle?

898

---

What is a system tablespace and when it is created?

917

---

What is the meaning of recursive hints in oracle?

992

---

What is a cursor and what are the steps need to be taken?

1111

---

How to call a stored function with parameters?

968

---

How to create a new table in your schema?

1025

---

What is the parameter mode that can be passed to a procedure?

978

---

Explain the use of owner option in exp command.

989

---

What are the benefits of ordbms?

1022

---

How many file formats are supported to export data?

1133

---

How different is ms access and oracle?

986

---

Please explain joins in oracle?

1007

---