Google Bard is now able to code for you. I tested Bard by asking few questions on Oracle SQL. I wanted to know if Bard is capable of providing accurate answers. I have done a similar exercise with Chat GPT and that was an amazing experience. You can read more about my experiments with Chat GPT here and here.
DDL Statements
Just like I tried with Chat GPT, I decided to try few DDL Statements first. Question 1: Write a SQL query to delete a table called AP_INVOICES
The SQL query is accurate and there is explanation of the query and example of how to delete some of the data from the table. When I tried the same with Chat GPT it reminded me of the “CASCADE” option to delete foreign key constraints and then delete the table.
Next, I asked Bard my 2nd question.
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
