|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
||||
|
||||
|
Object (types, Body)?
how do you used object bodys I have some code below where I want to display "number street town county postcode" but how do I do this as
SELECT * FROM CITIZENADDRESS just displays CITIZENADDRESSI CITIZENID ADDRESS(HOUSENUMBER, STREET, TOWN, COUNTY, POSTCODE) BUYDATE SALLDATE Address Type Object Code:
CREATE OR REPLACE TYPE address_t AS OBJECT
(houseNumber VARCHAR2(4),
street VARCHAR2(30),
town VARCHAR2(30),
county VARCHAR2(30),
postcode VARCHAR2(8),
MEMBER FUNCTION fullAddress RETURN VARCHAR2);
Address Type Body Code:
CREATE OR REPLACE TYPE BODY address_t
AS MEMBER FUNCTION fullAddress()
RETURN VARCHAR2 IS
BEGIN
RETURN number || ' ' || street || ' ' || town || ' ' || county || ' ' || postcode;
END;
END;
Code:
CREATE TABLE citizenAddress
(citizenAddressID CHAR(5) CONSTRAINT pk_citizenAdd_Addressid PRIMARY KEY,
citizenid CHAR(5),
address address_t,
buyDate DATE,
sallDate DATE);
|
|
#2
|
||||
|
||||
|
Can you please tell me why you want to use objects in Oracle database?
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias) |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > Object (types, Body)? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|