it allows you to download Web site from the Internet to a local directory, building recursively all directories, getting HTML, images, and other files from the server to your computer.

🔆የምትፈልጉትን website offline download ማረግ ትችላላችሁ 🔆
like w3school.com
Tutorialspoint.com

Using Run SQL Command Line
We described the full steps on below post ⬇️
———————
AI Programming @freecodecs
Hope this will be helpful 🙏🏽

Steps Using Run SQL Command Line
——————————————————
Step 1: Open Run SQL Command Line

Step 2: Write and enter the following without quotations and semicolon
‘connect system’

Step 3: Enter your password which is you gave when you install Oracle Enterprise program and press enter(*you won’t see it when you write it’s just blank)

Step 4: Alter the HR database account to access it every time - write and enter the following without the quotation and with the semicolon this time
‘alter user hr account unlock;’

Step 5: Now create user and password for manipulation of HR account - also write enter the following without the quotation and with semicolon
‘alter user hr identified by hr;’

Step 6: Write and enter ‘connect’ then enter user name & pass, write and enter twice ‘hr’ for the username and password

•NB• Now you can use the Oracle SQL Program anytime but when you use it on next launch which is after exiting and starting again skip Step 4 & 5
———————
AI Programming @freecodecs
As always :
Have a Lit 🔥 Practice Folks 🙌🏽

📎🗓 Figure DB 1.1

Database Exercise Questions
———————
N.B. Consider the database shown above in Figure DB 1.1, whose schema is shown and do the practical exercises below.

(We assume you have installed Oracle’s default HR(Human Resource) database, it’s comes as a compacted package within the Oracle Enterprise 11G program.)
—————————
Exercise Instruction : Write the SQL command used to manipulate in Oracle SQL Command Line program.

•Ex 1• Select and display all records from jobs table where it’s job title words started with ‘A’ character

•Ex 2• Display different /not duplicated/ maximum & minimum values of records from jobs table

•Ex 3• Display department names records from departments table whose location ID’s are 1700

•Ex 4• Display all records of jobs table in minimum salary ascending order whose job title had ‘P’ character in it

•Ex 5• Display first & last name, email, and salary records of employees table whose first name ends with character ‘y’ in email descending order

•Ex 6• Display first name, last name and salary records from employees table whose salary is either 12008 or 3000

•Ex 7• Display city and postal code records whose last character of city record neither ends with ‘y’, ‘e’ nor ‘a’ from locations table

•Ex 8• Display employee Id, first name, phone number and email records from employees table whose hires 4000 days before server date

•Ex 9• Display average, minimum and maximum salary values only by using functions from employees table

•Ex 10• Display employees of first name, last name and salary records whose hire date is January 07 2002 and whose salary is either 6500 or 8300

For SQL Commands reference please review the pdf short note attached and pined earlier.
———————
AI Programming @freecodecs
Have a Lit🔥 Practice Folks 🙌🏽

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 👽