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.