Answers for "how to use sql"

SQL
9

SQL

CREATE TABLE friends (
   id INTEGER,
   name TEXT,
   birthday DATE
);

INSERT INTO friends (id, name, birthday) 
VALUES (1, 'Jane Doe', '1990-05-30');


INSERT INTO friends(id , name , birthday)
VALUES(2 , 'APOORV' , '2000-2-2');



UPDATE friends
SET name = 'Jane Srivastava'
WHERE id = 1;

ALTER TABLE friends 
ADD COLUMN email TEXT; 


UPDATE friends 
SET email =  '203029@klsafjls'
where id  = 1; 

UPDATE friends 
SET email =  '203029@klsafjls'
where id  = 2;

DELETE FROM friends 
WHERE id = 1;


SELECT * 
FROM friends;
Posted by: Guest on May-25-2020
0

how do you use sql

Our web application uses Oracle database and 
I normally write queries to do Data validation. 
For example: 
I create data from UI or I send POST request
from API then I write query to verify that
data was successfully and correctly inserted
into database. Our database consists of
many tables, so most of the time,
I need to write queries that involve joins.

CAN MENTION: Since our application has
large sets of data, data is stored into
Oracle and to another CACHE database. 
I write queries to test data that both are in SYNC(same).
Posted by: Guest on January-14-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language