Sql updating table from temp table

posted by | Leave a comment

Our database receives JSON documents from external systems.

sql updating table from temp table-58

A GLOBAL TEMPORARY table has a persistent definition but data is not persistent and the global temporary table generates no redo or rollback information.For example if you are processing a large number of rows, the results of which are not needed when the current session has ended, you should create the table as a temporary table instead: The global temporary table will be created in the users temporary tablespace when the procedure populates it with data and the DIRECT_IO_COUNT will be used to govern the IO throughput (this usually defaults to 64 blocks).The landmark book "Advanced Oracle SQL Tuning The Definitive Reference" is filled with valuable information on Oracle SQL Tuning.In that case, it will return a multi-row table (each table row will match one JSON object in array) instead of single row table.This function can also open nested/hierarchical JSON object (I will describe this in a separate post).

Leave a Reply

Local sex online free no sign up