Log in
HomeClass Notes1,200,000CA670,000

Computer Programming and Analysis DBS301 Lecture Notes - Lecture 2: Sql*Plus

205 views4 pages
crimsonshark113
17 Nov 2015
School
Seneca College
Department
Computer Programming and Analysis
Course
Computer Programming and Analysis DBS301
Professor
Tanvir Alam

For unlimited access to Class Notes, a Class+ subscription is required.

Document Summary

Initiate a sql*plus session using the user id and password provided by your instructor on the zenit server for neptune database: display the employee_id, last name and salary of employees earning in the range of to. Sort the output by top salaries first and then by last name. 7 rows selected: modify previous query (#1) so that additional condition is to display only if they work as. 3 where salary >= 8000 and salary <= 15000. 174 abel 11000: modify previous query (#2) so that displays same job titles but for people who earn outside the given salary range. 3 where salary < 8000 and salary > 15000. 5 order by salary, last_name; no rows selected: display the last name, job_id and salary of employees hired before 1998 list the most recently hired employees first. 13 rows selected: modify previous query (#4) so that displays only employees earning more than ,000.

Get access

Grade+
$40 USD/m
Billed monthly
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
10 Verified Answers
Class+
$30 USD/m
Billed monthly
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
7 Verified Answers

Related Documents

Computer Programming and Analysis DBS301 Lecture Notes - Lecture 5: Curtis Davies, Oxford Science Park
crimsonshark113
Computer Programming and Analysis DBS301 Lecture 3: DBS301 - Lab3
crimsonshark113
Computer Programming and Analysis DBS301 Lecture Notes - Lecture 10: Data Dictionary, Data Definition Language
crimsonshark113

Related Questions

Write a program called Lab 5 that has 3 methods and a main method:
1) Method isUserNameValid has 1 parameter of type string and the method returns a value of type
boolean. If the parameter has less than 8 characters then the method returns false, otherwise it
returns true.
2) Method compare has 3 parameters all of type int and has a String return type. This method will
return
a. “All Same” if all 3 parameters are equal,
b. “All Different” if all 3 parameters are different.
c. “Mix number(s)” two of the numbers are the same and the 3rd is different.
3) Method isValid has 1 parameter of type int and returns a boolean value; the method returns true if
the parameter is in the range 0,…,100 inclusive, otherwise the method returns false.
4) Main method. I want you to test methods isValid & isUsernameValid one time with a valid data
and another time with an invalid data. As for method compare test it 3 times so you can get the 3
different possible outcomes.
Example to test the isUserNameValid method

5. Which of the following Java expressions do NOT have a value of 0. (A) ((double) 1) / ((int) 2) (B) (int) (((double) 1) / 2) (C) (double) (1 / 2) (D) 1 / 2 (E) (int)1.0 / 2

57. Line 5 (A) for (int j = -i*2; j<= i*2; j++){ (B) for (int j = 0; j< i+2+1; j++){ (C) for (int j = -i; j> i; j++) { (D) for (int j = 0; j<= i*2; j++){ (E) for (int j = i; j<= i+2; j+i) {