Informatica

Read SAP tables with Oracle APEX 01 The Views

Pubblicato il

Do you have an Oracle Database with an APEX environment? Do you have a SAP system installed on an Oracle database? Can your APEX database access to the SAP Database? (For example with a @mysap dblink) Yes? OK! Let’s have fun! But First: Disclaimer The information contained in this article is for general information purposes […]

Informatica

APEX: Creating Tables and Views with Quicksql

Pubblicato il

If you’re creating an application in Oracle Database, Oracle Quick SQL can be a very  useful tool. This  application provides a quick way to generate the SQL required to create a relational data model from an indented text document. However It’s not designed to be a replacement for data modeling, it is simply a quick start. Once […]

Informatica

Agrippa e la Cartografia

Pubblicato il

Immaginate di essere nell’antica Roma e che Agrippa (noto anche per aver restaurato e costruito numerosi acquedotti romani) vi avesse chiesto di riportare su una bella mappa dell’epoca la posizione degli acquedotti. Immaginate anche di avere con voi anche il nuovissimo telefono Aifon Ics con rilevatore GPS preciso al decimo di millimetro e capace di […]

Informatica

APEX Tiny CRM 09 The End

Pubblicato il

Next Article: APEX Tiny CRM 08 Apply Branches. Our Tiny CRM is finished. Clearly this is only a Proof to test Blueprint feature in Apex. I think it’s very powerful and I hope it will improve more and more in the future. Here the app Tiny CRM!!! A Recap for the code: The draw.io Diagram (copy […]

Informatica

APEX Tiny CRM 08 Apply Branches

Pubblicato il

Previous Article: APEX Tiny CRM 07 Apply Views.   In the left side menu we have three Items Accounts, Contact and Project, for each element we have a Master-Detail Page with: 1 Form (Master) 2 Classic Report (Detail) So we have 3 Pages x 2 Classic Report. In total we have: 6 Classic Report but with […]

Informatica

APEX Tiny CRM 07 Apply Views

Pubblicato il

Previous Article: APEX Tiny CRM 06 Apply LOV. In the left side menu we have three Items Accounts, Contact and Project, for each element we have a Master-Detail Page with: 1 Form (Master) 2 Classic Report (Detail) So we have 3 Pages x 2 Classic Report. In total we have: 6 Classic Report but WITH NO […]

Informatica

APEX Tiny CRM 06 Apply LOV

Pubblicato il

Previous Article: APEX Tiny CRM 05 Create LOV. We have the App and we have the three List of Values, now let’s match them: In the left side menu we have three Items Accounts, Contact and Project, for each element we have a Master-Detail Page with: 1 Form (Master) 2 Classic Report (Detail) 1 Modal Form […]

Informatica

APEX Tiny CRM 05 Create LOV

Pubblicato il

Previous Article: APEX Tiny CRM 04 Create APEX App. The Blueprint wizard has just created our App but we need some customization. The App needs three List of Values (LOV) one for Account one for Contact and one for Project but the wizard create only a LOV (a Bug??). So we have to: Create 2 LOV […]

Informatica

APEX Tiny CRM 04 Create APEX App

Pubblicato il

Previous Article: APEX Tiny CRM 03 Execute DDL. Login into http://apex.oracle.com  In App Builder let’s Create a new Application: Tiny CRM, open Blueprint and do some stuff: Add Page -> Master Detail fill the form Page Name : ACCOUNT Table : CRM_ACCOUNT Primary Display Column : NAME, Secondary Display Column : CITY Detail Table1 : CRM_ACCOUNT_CONTACT […]

Informatica

APEX Tiny CRM 03 Execute DDL

Pubblicato il

Previous Article: APEX Tiny CRM 02 Create DDL. Now we are ready to login into http://apex.oracle.com  go to SQL Workshop -> SQL Scripts create and run the script with our SQL code created in the previous article: — drop objects drop table crm_account cascade constraints; drop table crm_contact cascade constraints; drop table crm_project cascade constraints; drop […]