xxxxxxxxxx
try this online tool, it's free and support multilangs (SQL, MySQL, C, C++, PHP, Node, Deno, ..etc)
https://www.mycompiler.io/new/sql
xxxxxxxxxx
This is a good SQL editor:
https://www.tutorialspoint.com/execute_sql_online.php
xxxxxxxxxx
12
Create table sub (sub_id number (3) primary key, sub_name varchar2 (10), Sub_code number (3), sub_id number(3), foreign key (sub_id) references sub (sub_id));
xxxxxxxxxx
123456789101112131415161718192021222324252627282930
CREATE TABLE Publisher (ID INT PRIMARY KEY,Name VARCHAR(100) NOT NULL);INSERT INTO publisher (ID, name) VALUES(1,'Penguin Random House'),(2,'HarperCollins'),(3,'Phoenix Press,INC'),(4,'St. Bernadette Publishing House Corporation'),(5,'Morlanda Publishing');CREATE TABLE Book (ID INT PRIMARY KEY,Title VARCHAR(100) NOT NULL,Isbn VARCHAR(20) NOT NULL,Publication_year YEAR NOT NULL,Publisher_id INT NOT NULL,FOREIGN KEY (publisher_id) REFERENCES Publisher(ID));CREATE TABLE Author (ID INT PRIMARY KEY,First_name VARCHAR(50) NOT NULL,Last_name VARCHAR(50) NOT NULL);CREATE TABLE Writing (Book_id INT NOT NULL,Author_id INT NOT NULL,FOREIGN KEY (book_id) REFERENCES Book(ID),FOREIGN KEY (author_id) REFERENCES Author(ID));
xxxxxxxxxx
123456789101112
create table customers (customer_id[int],first_name[varchar(100)],last_name[varchar(100)],age[int],country[varchar(100)]);
xxxxxxxxxx
12
CREATE TABLE EMPLOYEE(NAME VARCHAR2(20),EMAIL VARCHAR2(20),DOB date);INSERT INTO EMPLOYEE VALUES('ROHAN','rehangmailcom','20');
xxxxxxxxxx
select cart.Id, cart.UpdatedOnUtc,cart.CreatedOnUtc, cart.RentalEndDateUtc,cart.RentalStartDateUtc, map.Quantity,
cart.CustomerEnteredPrice,cart.AttributesXml,cart.ProductId,cart.CustomerId,cart.ShoppingCartTypeId,cart.StoreId
from AUR_ShoppingCart_WishList_Mapping map,ShoppingCartItem cart where cart.Id = map.ShoppingCartItemId and map.WishListId = '55'