Quick SQL

Oracle Application Express is a rapid development tool for Web applications on the Oracle database.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Quick SQL

Post by admin »

Please note that indentation is important in the code,

Code: Select all

# settings = db: "18c", apex: true, api: true, schema: "erpstuff", prefix: "JS"
# PK: "seq", genPK: true, history: true, verbose: true
# auditcols: true, createdByCol: "created_by", createdCol: "creation_date", updatedByCol: "updated_by", updatedCol: "updation_date"

depts /insert 5
   name /nn
   location
   country
   emps /insert 10
      name /nn vc50
      email /lower
      cost center num
      date hired
      job vc255

view emp_v depts emps
Video explaining QUICK SQL and APEX APP Development,

https://youtu.be/38DnSRbezds
Malik Sikandar Hayat
admin@erpstuff.com
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest