Solved

working with Oracle Designer 6i

Posted on 2004-04-09
3
675 Views
Last Modified: 2007-12-19
Hi all,

I am at present working with Oracle Designer.  I am new to it.  See if anybody could  help me out.  here are my following questions.

1) We have something called Unbound and bound items in Ocl, designer.  I understand bound items are equivalent to db items and unbound items are equivalent to non-db items in Dev. forms.  Is it right? If we include any unbound item and select SQL expression, how to write queries in it?  say for e.g.my query shud be like
Difference between date of birth(db item) and sysdate.
2)  We have something called item groups in ocl. designer.  what is it.  When and how shud it be included in OCl. desginer.  Is it mandatory?
3) In D2k forms, We use to base a block on a table. once, we select the table, all the fields will be listed in the DB wizard.  In a similar way, how can we bring all the table fields listed in Orcl. Designer.  OR shud we include them manually?
4)  Difference between Module component and module sub-component?  Are they same like Blocks and items in D2k forms.
5) How to write validation triggers, and client side PL/sql units in oracle designer?
6) can we create object libraries on Oracle designer.  how?
7) How to declare Visual attributes on Ocl designer and include it to an item?

Any help please.

Thanks

Srigupta

0
Comment
Question by:srigupta
3 Comments
 
LVL 22

Accepted Solution

by:
Helena Marková earned 75 total points
ID: 10810830
1) You are right. The manipulation with unbound items is the same as with bound items is:
....WHERE :block1.date_of_birth BETWEEN sysdate-30 AND sysdate
2) Items groups are optional. It is used for grouping of items in a "logical" groups. You can add it/remove it everytime you need.
3) There is similar wizard in the Designere there. You can also add/remove items manually later.
4) You can read "Module sub-components" in the on-line help. Components and sub-components are items.
5) Validation triggers are generated automatically. You can write all triggers such way: Application Logic->Events
6) No, object libraries cannot be created in Designer. You can create only PLL libraries.
7) Visual attributes cannot be declared in Designer. You have to create an item in object liubrary (OLB) with desired attributes and use this item as template object in Designer.

Designer is a complex tool but it is worth to learn it and use it for form generation.
I advice you to read carefully Designer on-line help: "Generating Oracle Forms Applications". I have learned Designer such way.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MULTIPLE DATE QUERY 15 91
Use of Exception to end a Loop 3 45
Read XML values 8 42
Using SQL*PLUS issue with where statement with trunc function 3 29
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question