Oracle Insert BLOB

Inserting BLOB data into an Oracle database can be achieved through several methods. 1. Inserting Directly from a Buffer/Variable: DECLARE v_blob_data BLOB; BEGIN -- Populate v_blob_data with your binary data -- For example, from a RAW variable or a file read into ... Read more

Oracle Update BLOB

Updating a BLOB (Binary Large Object) in Oracle can be achieved using several methods. 1. Updating with a Buffer (Direct Data): UPDATE your_table SET your_blob_column = :new_blob_data WHERE primary_key_column = :key_value; 2. Updating by Selecting a LOB from Another Table or Source: UPDATE ... Read more

Export data from PostgreSQL to JSON via command line on MacOS

Want to export PostgreSQL data to JSON Lines (JSONL) file via Command Line Interface (CLI) on MacOS? Using pg-cmd, Command Line Interface (CLI) client for PostgreSQL, you can unload PostgreSQL data to JSON easily and fast. Direct Interaction or Scripting and Automation. No need to install ... Read more