SQLize | PHPize | SQLtest

CREATE TABLE SUPERHERO( NAME VARCHAR(100), AGE INTEGER, BIRTH_DT DATE, ALTER_EGO VARCHAR(50) ); ALTER TABLE SUPERHERO ADD RATING INTEGER; INSERT INTO SUPERHERO (NAME, BIRTH_DT, RATING, ALTER_EGO) VALUES ('Narasha Romanoff', '01-AUG-1999', 59, 'Black Widow'); UPDATE SUPERHERO SET RATING = 34 WHERE NAME = 'Narasha Romanoff'; SELECT NAME, AGE, BIRTH_DT, ALTER_EGO, RATING FROM SUPERHERO; CREATE TABLE ABC( ALTER_EGO VARCHAR(50), COL INTEGER ); INSERT INTO ABC (ALTER_EGO, COL) VALUES ('Black Widow', 15); SELECT * FROM ABC; SELECT * FROM SUPERHERO CROSS JOIN ABC; SELECT NAME, AGE, BIRTH_DT, SUPERHERO.ALTER_EGO, RATING, COL FROM SUPERHERO, ABC; INSERT INTO SUPERHERO(NAME, BIRTH_DT, ALTER_EGO) VALUES('PAVLOV PAVEL', '13-JUNE-2002', 'SPEDERMAN') SELECT NAME, AGE, BIRTH_DT, SUPERHERO.ALTER_EGO, RATING, ABC.ALTER_EGO, COL FROM SUPERHERO INNER JOIN ABC