Page 1 of 1

Quick SQL

Posted: Wed May 05, 2021 6:10 pm
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