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 control file used for?

0 Answers  

---

what is pragma?

2 Answers  

---

How to create tables for odbc connection testing?

0 Answers  

---

I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?

2 Answers   Philips,

---

how to unbreak sequence numbers during intereptions

1 Answers   Ion Exchange,

---

what is the difference between UNION AND UNIONALL

4 Answers  

---

Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.

1 Answers   IBM,

---

How to check database size in Oracle?

0 Answers   MCN Solutions,

---

How to create a new table in your schema?

0 Answers  

---

What is a table in oracle?

0 Answers  

---

which sql command we can use to get a print out from oracle?

2 Answers   iFlex, INDUS,

---

What is a table index in oracle?

0 Answers  

---