shivakrishna.ganji

 Profile Answers by shivakrishna.ganji 

• Dec 20th, 2009

 

select column_name as User_defined_name from table_name;

jpundalik

 Profile Answers by jpundalik 

• Dec 28th, 2009

 

Below is the syntax can be used for creating user defined data type in Oracle

create or replace type type_name as object
(
add fields and types..
)

Example:
create or replace type address as object
(addr1 varchar2(100),
City varchar2(30),
phone varchar2(15)
);