Create Table Using SQL Query Browser

In this lesson, you will learn how to work with SQL Query Browser that platform provides.


  • Go to Navigation → Developer → SQL Query Browser.
  • Create a table OE_ORDER_HEADERS_ALL with the required fields.
  • Create an index on the order_id field.
  • Create sequence for the primary key field in the customer schema.
  • Create synonym for the primary key field  in the rapapp platform schema.
  • Grant the permissions on customer schema primary key field to platform schema.
  • Here “apps” is the platform schema. 

      

  • By clicking on the Run Script button, all the script is executed.
Note: You can perform all the DB actions, the way that you do in Oracle SQL Developer

Location

101 California Street, Suite 2710
San Francisco, CA 94111


440 N. Wolfe Rd.
Sunnyvale, CA 94085


Office 11, 5th Floor, Building 9,
Mindspace IT Park
Hyderabad 500081

p: +1 (844) AT CloudIO (844-282-5683)
f: +1 (650) 300-5247 | e: sales@cloudio.io
© 2009, 2017 CloudIO Inc. | Terms of Use | Privacy Policy