- oracle
- sample scheme
- DEFAULT username: SYSTEM
- pass: 123
- conn sys/123@localhost:1521/XEPDB1 AS sysdba;
- Assignment:
- HR.EMPLOYEES - Fix the TABLE INTO the ascending ORDER
- SELECT DEPARTMENT_NAME AS DEPARTMENTNAME FROM hr.departments;
- Changes the name OF TABLE during the runtime
- SELECT * FROM jobs WHERE job_title LIKE 'S%e';
- Begins WITH S AND ends WITH e
- SELECT * FROM jobs WHERE job_title NOT LIKE 's%';
- WHERE there IS no "s".
- SELECT * FROM hr.jobs WHERE job_title LIKE '_r%';
- WHERE job title has r IN the SECOND position
- SELECT * FROM hr.jobs WHERE job_title LIKE '%es%';
- IN ANY position
- SELECT * FROM hr.regions WHERE REGION_ID='1' OR Region_Name='Europe';
- SELECT * FROM hr.regions WHERE REGION_ID='2' OR Region_ID='4';
- SELECT * FROM hr.regions WHERE NOT REGION_ID='1'; - this will show ALL except FOR 1
- SELECT * FROM departments WHERE NOT LOCATION_ID='17000';
- SELECT CONCAT(CONCAT(job_title, ' '), max_salary) AS job_information FROM hr.jobs; - this IS used FOR the concatenation WITH SPACE
- CONCAT(CONCAT(job_title, ' '), max_salary)
- SELECT COUNT(*) FROM hr.jobs; - take the totalnumber OF tables IN hr.jobs
- assignment wildcards - research about it
Recent Pastes