We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

working with Oracle Designer 6i

srigupta
srigupta asked
on
Medium Priority
765 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

Comment
Watch Question

programmer-analyst
CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.