devDFdevDF
  • Home
  • Education
  • Certifications
  • Professional Experience
  • Blog
  • More

JSON

Google

Automating Data Flow from Marketing System to Google Sheets using Python

Introduction In today’s data-driven business landscape, the efficient handling of data is critical for making informed decisions and shaping effective strategies. However, managing data from various sources can be a time-consuming and error-prone process. In this blog post, we will explore a Python script that automates the flow of data Read more…

By dfmaster, 2 yearsOctober 29, 2023 ago
JSON

Extracting Attendant Information from JSON in Oracle Using JSON_VALUE and JSON_TABLE

In recent database management tasks, I encountered the need to extract an “attendant” ID from a JSON document stored in a CLOB column within the table df_nsf_mov_det. This information was crucial for storing the value in another table. The challenge lay in the fact that the “response” field contained a Read more…

By dfmaster, 2 yearsOctober 29, 2023 ago
  • Blog
  • Blog
  • Certifications
  • Contact
  • Education
  • Home
  • Professional Experience
Hestia | Developed by ThemeIsle