Editing SQL 2
Jump to navigation
Jump to search
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then publish the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 1: | Line 1: | ||
=== SQL Exercise 3 === | === SQL Exercise 3 === | ||
Create the tables and insert data from the following files [[https://github.com/DaStanzel/Unterlagen-Datenbanken-CB/blob/main/%C3%9Cbungen/SQLUebung03/parts.sql Parts insert and create tables]] [[https://github.com/DaStanzel/Unterlagen-Datenbanken-CB/blob/main/%C3%9Cbungen/SQLUebung03/tennis-tables.sql Tennis Create Tables]] [[https://github.com/DaStanzel/Unterlagen-Datenbanken-CB/blob/main/%C3%9Cbungen/SQLUebung03/tennis-insert.sql Tennis Insert Data]] | Create the tables and insert data from the following files [[https://github.com/DaStanzel/Unterlagen-Datenbanken-CB/blob/main/%C3%9Cbungen/SQLUebung03/parts.sql Parts insert and create tables]] [[https://github.com/DaStanzel/Unterlagen-Datenbanken-CB/blob/main/%C3%9Cbungen/SQLUebung03/tennis-tables.sql Tennis Create Tables]] [[https://github.com/DaStanzel/Unterlagen-Datenbanken-CB/blob/main/%C3%9Cbungen/SQLUebung03/tennis-insert.sql Tennis Insert Data]] | ||
create table - Create the tables DEPT and EMP from the file dept_emp.sql. ( [[https://github.com/DaStanzel/SQLUebung02/blob/main/dept_emp.sql EmpDept.sql]] ) * | |||
<nowiki>*</nowiki>If there are issues with the Date Format in Oracle SQL Developer change them in Tools -> Preferences -> Database -> NLS -> Date Format: "DD-MM-YY" | <nowiki>*</nowiki>If there are issues with the Date Format in Oracle SQL Developer change them in Tools -> Preferences -> Database -> NLS -> Date Format: "DD-MM-YY" |