DB - Oracle Exercise 1 :Answers
————————————————
•Ans Ex 1
SELECT * FROM JOBS WHERE JOB_TITLE LIKE ‘%A_%’;

•Ans Ex 2
SELECT DISTINCT MIN_SALARY, MAX_SALARY FROM JOBS;

•Ans Ex 3
SELECT DEPARTMENT_NAME FROM DEPARTMENTS WHERE LOCATION_ID = 1700;

•Ans Ex 4
SELECT * FROM JOBS WHERE JOB_TITLE LIKE ‘%P%’ ORDER BY MIN_SALARY;
(SELECT * FROM JOBS WHERE JOB_TITLE LIKE ‘%P%’ ORDER BY ASC MIN_SALARY;)

•Ans Ex 5
SELECT FIRST_NAME, LAST_NAME, EMAIL, SALARY FROM EMPLOYEES WHERE FIRST_NAME LIKE ‘%y’ ORDER BY EMAIL DESC;

•Ans Ex 6
SELECT FIRST_NAME, LAST_NAME, SALARY FROM EMPLOYEES WHERE SALARY = 12008 OR SALARY = 3000;

•Ans Ex 7
SELECT CITY, POSTAL_CODE FROM LOCATIONS WHERE CITY NOT LIKE ‘%e’ AND CITY NOT LIKE ‘%y’ AND CITY NOT LIKE ‘%a’;

•Ans Ex 8
SELECT EMPLOYEE_ID, FIRST_NAME, PHONE_NUMBER, EMAIL FROM EMPLOYEES WHERE HIRE_DATE > SYSDATE - 4000;

•Ans Ex 9
SELECT MAX(SALARY) as “Max Salary”, MIN(SALARY) as “Min Salary”, AVG(SALARY) as “Average Salary” FROM EMPLOYEES;

•Ans Ex 10
SELECT FIRST_NAME, LAST_NAME, SALARY FROM EMPLOYEES WHERE HIRE_DATE = ‘07-JUN-02’ AND (SALARY = 6500 OR SALARY = 8300);
———————
AI Programming @freecodecs
Have a Lit🔥 Practice Folks 🙌🏽

🔆የተለያዩ programming language video/course ደረጃቸውን የጠበቁ እና ከነ exercise file,software ለምትፈልጉ @alphacoder12
ላይ inbox me
❌የ YouTube video አይደሉም❌
✔️ Java ✔️ PHP
✔️ html/css ✔️JavaScript

✔️ Android studio ✔️Flutter
✔️Android Oreo developer
...የመሳሰሉትን
- Softwares
- application
- pc formatting

contact us
@alphacoder12
☎️ 0993809248

HTML and CSS Website Template
#share

👇👇👇👇👇👇👇👇👇

Programming 2(Cpp)
____
PDF, Different Exercise, Assignment and Final Project
#share

#pc_app
YouTube ላይ IDM አልሰራም ላላቹ
ገራሚ video download ማረጊያ

Alibaba Netpreneur Training Opportunity
—————————
Program Date:
March 15 – March 25, 2020 at Alibaba's headquarters in Hangzhou, China.

Program Costs:
Covered:
    • Training cost.
    • Hotel accommodation (shared room).
    • Field trip and site visit transportation costs.
    • Daily meal allowance for breakfast (included in the hotel), lunch and dinner.

https://activity.alibaba.com/supplier/alibaba-netpreneur-training-ethiopia-1-.html?spm=a2738.12425552.jzcei40h.1.748d3b01X8CY0u&auto_redirect
—————————
Join The Underground Coding Movement!
AI Programming @freecodecs
Have a Lit🔥Practice Folks 🙌🏽

እንኳን ለኢትዮጲያ አሐዱ ምዝዋር ምጥቀት ታሪካዊ ቀን አበቃን !

We would like to say all Ethiopians Congratulations for this historic day which is for the first Ethiopian ETRSS-1 satellite 🛰 successful launching!
——————————
Join The Underground Coding Movement!
AI Programming @freecodecs

Today we will discuss an amazing app called ❇️source code❇️
----------------------------------
👉over 1222 programs source code of different programming language like
🔘C C# C++ JAVA
🔘CSS HTML JAVASCRIPT
🔘PHP Python XML SQL
and many more programming language

💠if u want to learn about programming this app will help u 100%


✳️we uploaded the applications on our channel
👇👇👇👇👇👇👇

👽 FACEBOOK HACKING PDF 👽

OOP Exercise GUI (Java)
—————————
This simple GUI shows how ActionEvents & Graphical Components like Buttons, Text Area, Panel, Frame implanted and also how text saved & retrieved by clicking single buttons from text file in Java.

P.S. We will post the (Login.java & Main.java) source files below.

N.B. To work with the below attached files you must enclose both files under the eventgui package.

Peace ✌🏽 out !
—————————
Join The Underground Coding Movement!
AI Programming @freecodecs

OOP GUI Exercise (Continues)
—————————
Attached (Login) Java Class File
—————————
Join The Underground Coding Movement!
AI Programming @freecodecs
Have a Nice Practice Folks 🙌🏽

OOP GUI Exercise (Continues)
—————————
Attached (Main) Java Class File
—————————
Join The Underground Coding Movement!
AI Programming @freecodecs
Have a Nice Practice Folks 🙌🏽