Photo by Possessed Photography on Unsplash

ChatGPT for SQL Queries

Arun Raj
2 min readDec 20, 2022

--

You might have already tried out ChatGPT. So have I. Today I wanted to share some of my experiences using ChatGPT. For this post, I will share the results of the questions that I had regarding SQL Queries.

I was curious to know if I can get accurate SQL statements. And to my surprise, YES!!

DDL Queries

I decided to try few DDL Statements first.

Question 1: Write a SQL query to delete a table called AP_INVOICES

Question 2: Write a sql query to alter the table ap_invoives and add a primary key called ap_invoice_id_pk on column invoice_id

Here you will notice the additional information provided regarding dropping the existing primary key. I didn’t ask that in my question. However, ChatGPT provided that information. And that is amazing!!

DML Queries

It was now time to test the DML Statements.

--

--

Arun Raj

Mostly write about Oracle Cloud ERP and EPM related Topics. Interested about emerging AI technologies, Python and Low Code Tools