Tuesday, October 27, 2015

Oracle Objects

Creating an plsql Object

CREATE OR REPLACE TYPE address AS OBJECT
(house_no varchar2(10),
 street varchar2(30),
 city varchar2(20),
 state varchar2(10),
 pincode varchar2(10)
);
/

No comments:

Post a Comment