JAA149:

Sounds good, you are getting there.

Thanks for the answering my question with the "tiny pics process".

__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.

JAA149:

Looking for one of the responses, I noticed I had overlooked your question:
================================================== =============
QUESTION : Lets say I want to develop a fully functionally Database for a company with 20 to 50 users who are on an Intranet running windows XP professional SP3 for ORDERS booking and INVOICE raising. Now I have done all the background study for Database Modeling and Design including set theory and logic, ERD and its notations and all others. Using oracle 10g databse express edition and APEX 3.2 will i be able to produce a fully functionally databse application (backend + fronend) and install/deploy there.

My response:
Yes you will be able to create a very dynamic, data -centric application model. By going thru the book, you will be able to produce your model in "no time" at the same time gaining knowledge about Oracle.

I am in the process of upgrading my laptop Oracle 10g to APEX 3.2. I have spent 2 days going thru Oracles installation guide until my eyes-crossed. I hope to have this done soon and go for the: OTN APEX 3.2 2009 Challenge.

Hope this helps.

__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.

Thanks peace95,

For you APEX 3.2 installation check these video out.

1 - For Oracle Database 10g Express Edition Installation
http://www.mandsconsulting.com/oracl...stall-tutorial

2 - For upgrading to APEX 3.2
http://www.mandsconsulting.com/insta...rough-tutorial

Plus there are many other videos relating to APEX 3.2.

I also got hold of another book which I plan to study once i finish the current book.

"Pro Oracle Application Express - 2008"

http://www.amazon.com/Oracle-Applica...7392578&sr=1-1

I the mean time I am desperately trying to find the books

"Hands-on Oracle Database 10g Express Edition for Windows"

http://www.amazon.com/Hands-Database...7392732&sr=1-1

As I said i am migrating from Access to Oracle and am totally ignorant about Schemas and the architect of Oracle Database. So far I know this is the perfect book for a totally new guy like me but can not find the book any where.

Do you think I should leave 10g express edition all together and move on to 11g.

Regards

Jawad

JAA149:

Thanks for the different references to the installation of 3.2. I successfully installed APEX 3.2 early this morning. I started reading the Installation guide then went back to the "OTN" site and found an article by a programmer and used it.

The book I suggest you use for a broader aspect of Oracle is wrox's book: Professional Oracle Programming by Rick Greenwald, Robert Stsackowiak, Gary Dodge, David Klein, Ben Shapiro and Christopher G. Chelliah. This book will answer all your questions about the Architecture, PL/SQL, OO-Relationship, my favorite.

I am sticking with Oracle 10g,because I installed it to my laptop 2 years ago which had the old version of apex 2.1. All I needed was the upgrade of apex version only. Although I am using the Hosted Account for the exercises in the Apex book, I am not sure which Oracle db is used. Since you have 10g loaded I would stick with that one. One thing about Oracle when they move from one version to another, the new version does not cancel out the previous version.

Hope this helps.

__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.

Hi all,

I need to learn Apex for my work and I keep getting stuck at page 49 ( I am playing with Rick's tables ), using Apex 3.2.1 and I receive the error: "ORA-02270: no matching unique or primary key for this column-list".

I have tried to play with some of my own, but I am getting an error on the same page.

Have you any idea what is causing this error?

Thanks a lot,

chantall

On page 49, what you are actually doing is creating a one-to-many relationship between two tables, Product and Orders. Because I don't know what two tables you are using, however I strongly suggest you use the tables in the book exactly as in the book. By all means, stick to the book. I suggest you compare your existing pages to the screens in the book, if they do not match do not move on, stop and fix program. Also, keep the errata sheet near.

Hope this helps.

__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.

Thanks Peace95,

I am using the exact tables Rick suggests. I am trying to add a relationship between ORDER_ITEMS and PRODUCTS.
That is my concern: I have used the exact same details he's got in the book, but I still receive errors.
On the same page I received errors when trying to play with some tables of my own ( adapted to his examples ). Strange..

Regards,

chantall,

You need to do the followeing verification:

• All Database tables: verify the table name, table fields and make sure they are named the same and in ALL-CAPS and in the same sequence;
• Verify each table has a designated Primary Key as in figures and designated foreign keys, which are needed to establish relationship. DO NOT use your tables just yet. Do exactly what is in the book;
• Which account are you using, the Oracle Account or a different account? Verify the Oracle version.

Try setting up a free account with Oracle and start over.

__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.