Here is a simple example of creating a declarative component to ensure a consistent look and feel for "Address" (Street, City, PostalCode, Country).
Nice definition from an OOW 2009 preso from Lynn M.
Declarative components are -
-Component definitions that are reusable across applications
-When changed, affect all pages that use them
-Made up of any number of other components
-Do not have data binding in their definition
-Published for use in the Component Palette
Now to the lab.
Nice definition from an OOW 2009 preso from Lynn M.
Declarative components are -
-Component definitions that are reusable across applications
-When changed, affect all pages that use them
-Made up of any number of other components
-Do not have data binding in their definition
-Published for use in the Component Palette
Now to the lab.
First the SQL to create the demo table -
Drop table myCusts;
Create Table myCusts
(
cust_nr varchar2(20) not null,
cust_name varchar2(40) not null,
cust_email varchar2(40) not null,
cust_telnr varchar2(40) not null,
cust_addressStreet varchar2(40) not null,
cust_addressCity varchar2(40) not null,
cust_addressZip varchar2(10) not null,
cust_addressCountry varchar2(40) not null,
cust_age number(3),
cust_salary number(8),
comments varchar2(255))
;
alter table myCusts add
primary key (cust_nr)
;
Create Table myCusts
(
cust_nr varchar2(20) not null,
cust_name varchar2(40) not null,
cust_email varchar2(40) not null,
cust_telnr varchar2(40) not null,
cust_addressStreet varchar2(40) not null,
cust_addressCity varchar2(40) not null,
cust_addressZip varchar2(10) not null,
cust_addressCountry varchar2(40) not null,
cust_age number(3),
cust_salary number(8),
comments varchar2(255))
;
alter table myCusts add
primary key (cust_nr)
;
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIuLe00YECNms97yVbVQsg2zABz1woudGnoBgr8ywUqIn25Rh7oWF_gRcj76wSM5xX5C1tFNRi5vLUGYI2THpowmNgDVLP7DgYUBs9fcq9MPw_epyQrxQWdX2FDSRKUaP3W4yHSZeRSkxh/s400/aa.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj82pVOLgjAi1FzGGxmUW0LESPjVsF6FiRjFglG5RpqLwfxhLEdJXT9yB9NXX3owMhmyU4_I7JxZw9bdqU96Ukp55QmJ48GKKipmlefCsduatmzD8_hNkPV1ojnYxJjf2lJiGO4xnhfzGWA/s400/bb.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9Z2wblo7MRbC8TlfDBNakdlAFOC-tVzUWl6cYLV-UN2c1N3xuMKb46N-GfrQ_kH7jlZx0dHtGbks9QA6BKlBLRW12cNLZfzLXsuYXkqC_jm-k2kCKrQC8iZCJ9Og4lsLgimyz5T_OWOIh/s400/cc.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh9bErlhlVGymdx4jBy4_YIscwE1rihYByjV7_0mwOwzKWq79uMkfzz9papSo9z5ZkJOuvRAMFohgrrGKkdZ68PyiTIxvOMVYeQTF9e-tDLmGPzXFqSeBunyGPWCL2jyxdHkpVs4FssdKzO/s400/dd.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYlu6QgzxZsvxCDAWKMhcqMLqym4WdpNxeRraCWUeR1IQpTlXy6xyw_FIEGw5Nw8DOLeoFhHFdC2ugW3E_2V3mMqIv0b6h6vngKmFlyzkZfv6CoQbgws2HbHm8Sjz99eNKN0RGsbf9xRhy/s400/ee.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqk-ddNWIgNZWzV92H-GfCE0ykeBQOUcoq9CshKP4sMHqHto69VTeY6fzO838xnEBTJuLXiIKksDkZA110qXkbHhxW9-Owu3_lK92T8mh4OGNQT1JNLu1Sd6_t-ZOP4Gcz0dnUj1wYKFJp/s400/ff.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4BnF2eDFIc4P3xDIYy1s-nnO90DhEU_6DRSMP6cpe7ZvayljMGE-FTGrPGmWpKXkkoQRRgUPGhxrgJMnf8Ta5Iucy4ab44qqrnjyePw6uW6LKRgj24D2F0rPDBrqVpG-QRxqajZb78mbW/s400/gg.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjynaP-bJjmzKCE5Ptwd6DCyLXXusBl6ELlhiWdN9leZf6UGc8kGmMFfRa3b115mDIhnPTLibrnGAsHvOUHbfK7U8bd-EVcT3dKHHGTGupkho-XKE-VmclV2EPAQsBzxbGFKLw_vJOjBVO2/s400/hh.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgy1NnBUT9gublRWsb6j_CbCxGmHp9xS0qrbsmX4MK6FR46x3RP17U5DmtraEZ7cUkKssaBliatjeov2gXgt79wlE-fOn3LVDiJ_zJ_oMZ0U0QgLymbOl4TuwVeHzuoTwEaGYrTRzu2OVOw/s400/ii.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi59_Rq93szjBnt1eyJLEQLI_BaQBSjPeSqyyGTzTiBY33jcfhA1QPNMCVNpPXWLFKUsFxyebZ-D8j13VkDq5HY7cp5miaqdKq5PV1km1PiKj4lumjR5HxahzNcud8-BCPoUTmGFyeok1Om/s400/jj.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCvX0q2g9ZF06h7AZnbOZvIq63i3gxT4Brbf7iqIiH3MGyEvcz-jfkzc8bKqGPxqXEzfBKu_YwbPtuZdv5d0RBp_NLCh36g2H_qkGCEXjvPSqZXqcoG0_zbYlAAi-QQZBDVaMm0HbW96OM/s400/kk.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnwWhoIKF9yw8E8Po1uNZ6OFppQD_Pmfgq-BZVV7AwbrL7SDNDnUNTrj8IO3wBF8q7XqseXee8z35zAN4rPHWn7mgfcyTnTvpLry6Os3hzARUB77kLVKCXxQX0qArTMcUGdrLoDcFHSlpl/s400/ll.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidj_FZEyhMBu992N97Qf-l-OJkzAuxwp_jblH_Eoizqw9FUhyL-zZB_ErVFvHa4h3boZdOI5LIXd1RP68lnptQXADBMwEZw1PTBenjJ8XrfIW5qsBnEXjv6lemT9dwZOoLUk6a4bmhplTl/s400/aa.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjrbEFLNUCdor9YX2qzVy8KbKNzItbTt3oF3x_8Bt_6jPnUeVjKwOJx_bDVROTUI0Dd4v-2w1Ji7W9izeRkPn_ZvbagwaBVcNg8f1_gipFPglHFBaWdLxGCG0xUxtxFGqf80vTFHnnlg2Jj/s400/bb.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgh7Tdo31iqGCtfvOkTez5wH9mQTf3WH9y96APymrH2x2Uzm48i3Ns1bGMr4IMFR2CBBeM3ogkUpSL5TgCrRosIRijY7DqTZLjAbY0SidP12Sk5sChMgI0mD6Ik_cKilYj8HUPEMrMFknNp/s400/cc.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiR-c8WprZgB9bSFL6oplwLYpUJbvoKvbJZe1RGyfjHWNgUuwk7a1_uixMcyZ_t4gp4GEmwtqK1hASUFOGG19ypwITdpA0V43a1-eZo5w5ykf9DuN4NJyxnAYt8TxxP5Yd0seTfTjTWPKOv/s400/dd.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKDF_NOETokQST1vXD_Ih89-fahjke9sq5EyuW1luRtcNhxASYmnhtTVZlcP2wPBt_aS_P9xqd2vDVl1zrIjdHA683pnwUaxFT-VkpNrCduv9mAlHtSl7OacO6JPg0srywAfe8aFLucmMJ/s400/ee.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKchJ5qK4mwUAXqjl9_p5znJUlnH6_exgX1M79s3I7SgSanTvsUptOQ9OeMwbXA_Jg9Tz0v_KSDDiceDuIF8zSaN2x2bLnnAAhntO8a2Jjn-D1UQVz_3mPnSnOIgPYv-5mfvt-0lpIjuX6/s400/ff.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8FyGKUym72wkqRhILDaKVU6bN9OUBOEUMoi_qacQu7_dAFDfFcIk-lZRDhTpiapNV8utWnVxvDypIqoCbrJCFmkEBpnW4XsbR3EwIqCcSyDcNWF29iXdHZ3RRiE8A3llECamsChYrTW3b/s400/gg.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiv1oSah9Q0jB5VWSlYENEWPH7ZUw3cG7LQHICPZLOd5gVyALq0N_FjrVC2_HPVErrj_MlBPZHUkXeweY_rzp2IjLwZWJpfBRvTWQZU1aq12G-COf7IrRyG8iwKW7QW21Ox0gjJfzGrlsiT/s400/hh.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhuhPo6Ily0EGNxjNQg3-_d5pWHiHou0-_i9mMCq_JiN4N_PIBzkUQogppGZU2HSHdvc0Jq4O9oZ_ngaI3mOmS6NjeS3sTOB_6fSFbsVMyctBvhMrFP77IQ6DAxN5fSsDn4dso2dy8NpRTU/s400/ii.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKSKsawUYWZq240JnwCUDEV7Sya5Ordau0C4yD8gcm1fiAYs0DEAL6BVpzsiyb-KLN7TGS1ytH4qa8nnF8gfyzKkumHcrUwO5WPIzRzpMFQIbqtfZMiaUp72EgFXep4_oNk-W6dGxQM0Ei/s400/jj.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhngA0Uvf8U-TIL6v-XsLajL7eosdjSwfX9Eki4bnP0lutEK12sIatC9QBCPSkgvAM95Co4ljRl9ZDpSoOp8hUkzV-HLMMq-kNOJPedBaY-Bu_N5VbrSQJcu08TXb7iqig6KdmNvfFkg1en/s400/kk.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSrElNX2HGc-B1tp6JA3BWJGx8FJ6aZJO1YB2mDXyWwY_Ysarz9i1QGJT07tMMpp7Ccu3ujcNIzRy2VeVUH-8O24NkzdY4BVq3xu-COecu-yyLaRc6qUFrbQ2eBBilFQql_DEb5Ooof2a7/s400/ll.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMo_LJdOghFL7Vm-3V6fkcxP-lTaQvsjkBvWAB7WK1lnSol_Ao-fEaodRVJbwF2TzqB5sHHJlkoU9BVL8kTOPQv8iiCKDAykccusc5RxcCywvqfSXMp-zN-je1Ybi2PyKpAPfAHPS3KBb9/s400/mm.jpg)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWX8QzZbShJf_q_Wc3QXqcYoTCTBcHjDT97uJviAXcTa0G-GWdcp4ohCJJ3mANoXSnjoY1WWahbTxyh5R6NjHLdnHsmV0UuwUgVut_aYXouiT6g2awa6xoly4nyw2UNJEYEtS0nAo5YxDj/s400/nn.jpg)