The SQL*Plus COPY command can copy data between two databases via SQL*Net. Syntax: USER1 @srcdb> copy usage: COPY FROM [db] TO [db] [opt] [table] { ([cols]) } USING [sel] [db] : database string, e.g., hr/your_password@d:chicago-mktg [opt] : ONE of the keywords: APPEND, CREATE, INSERT or REPLACE [table]: name of the destination table [cols] : a …
One of the web development projects using Oracle APEX I’m working on is to upload the content of a text file in csv format into database. By default, all files using the “File Browse..” element will be uploaded to the “wwv_flow_files” table which has structure as follows: [source language=”sql”] SQL> desc wwv_flow_files Name Type Nullable …
APEX to upload a text file and write into a table Read More »
Today I installed Oracle 11g (11.1.0.6) on my machine. I did not realize that Oracle APEX is a part of the standard database components. So after the 11g installation, I just follow simple steps (shown later below) for the post-installation. In order to access the APEX application, either the embedded PL/SQL gateway or Oracle HTTP …
Last week I had a chance to work on RMAN to duplicate the existing 3-node RAC database to another 2-node RAC database. In my case, the 2-node target already has running instances, the task here is to wipe out and copy data from production. Here is my note. I tried to put some comments to …
You can change the width of the NAME, TYPE and VALUE of “show parameter” in SQL/Plus. SQL> show parameter sga NAME TYPE —————————— —————————— VALUE—————————— lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 300M sga_target big integer0 SQL> column NAME_COL_PLUS_SHOW_PARAM format A20 SQL> column TYPE format A20 SQL> column VALUE_COL_PLUS_SHOW_PARAM format A20 SQL> show …
Change column width of show parameter in SQL Plus Read More »
There are lot of articles (example) talking about how to read a physical XML file and insert into Oracle database. Here is a little bit different. This shows you how to read XML directly from web’s URL then insert into a database table without involving a physical XML file. To manage the list of URLs, …
