PLZ help with the following: change the following sql to oracle sql meaning making run/ work on oralce sql live or oracle sql developper CREATE TABLE BOOK(num INT(20) NOT NULL AUTO_INCREMENT, title VARCHAR(20), year DATE,subject VARCHAR(20), checkedout DATETIME, checkedin DATETIME, PRIMARY KEY (num)); CREATE TABLE Client (CID INT(20) NOT NULL AUTO_INCREMENT, fname VARCHAR(25), lname VARCHAR(25), type VARCHAR(25), num INT(20), PRIMARY KEY (CID), FOREIGN KEY (num) REFERENCES emp.state(state_id)); CREATE TABLE author(id INT(10) NOT NULL AUTO_INCREMENT, year DATE, fName VARCHAR(20), lname VARCHAR(20), num INT(20), PRIMARY KEY (id)); ALTER TABLE author ADD FOREIGN KEY (num) REFERENCES book(num); ALTER TABLE client ADD CONSTRAINT client_ibfk_1 FOREIGN KEY (num) REFERENCES book(num);
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
PLZ help with the following:
change the following sql to oracle sql
meaning making run/ work on oralce sql live or oracle sql developper
CREATE TABLE BOOK(num INT(20) NOT NULL AUTO_INCREMENT, title VARCHAR(20), year DATE,subject VARCHAR(20), checkedout DATETIME, checkedin DATETIME, PRIMARY KEY (num));
CREATE TABLE Client (CID INT(20) NOT NULL AUTO_INCREMENT, fname VARCHAR(25), lname VARCHAR(25), type VARCHAR(25), num INT(20), PRIMARY KEY (CID), FOREIGN KEY (num) REFERENCES emp.state(state_id));
CREATE TABLE author(id INT(10) NOT NULL AUTO_INCREMENT, year DATE, fName VARCHAR(20), lname VARCHAR(20), num INT(20), PRIMARY KEY (id));
ALTER TABLE author ADD FOREIGN KEY (num) REFERENCES book(num);
ALTER TABLE client ADD CONSTRAINT client_ibfk_1 FOREIGN KEY (num) REFERENCES book(num);
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
