Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
createTable
--Oracle 11g Express Edition --please drop objects you've created at the end of the script --or check for their existance before creating --'\\' is a delimiter DROP TABLE FilmCotes; CREATE TABLE FilmCotes( idFilm INTEGER, idClient INTEGER, cote INTEGER); INSERT INTO FilmCotes (idFilm, idClient, cote) VALUES (1, 1, 1); INSERT INTO FilmCotes (idFilm, idClient, cote) VALUES (1, 2, 3); INSERT INTO FilmCotes (idFilm, idClient, cote) VALUES (1, 3, 4); INSERT INTO FilmCotes (idFilm, idClient, cote) VALUES (1, 4, 4); INSERT INTO FilmCotes (idFilm, idClient, cote) VALUES (1, 5, 5);
run
|
edit
|
history
|
help
-1
Srinivas
Rdbms
Detail1
Kartik DBMS Program
HELLO WORLD
Multiplication table
PL/SQL declaracionVariables
Srinivas
wq1
prgm1