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;
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).
Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
