Using Run SQL Command Line
We described the full steps on below post ⬇️
AI Programming @freecodecs
Hope this will be helpful 🙏🏽
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 🙌🏽
——————————————————
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 🙌🏽
AI Programming
———————————————— | 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)…
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
————————————————
•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
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
┈┈┈┈••●◉❖◉●••┈┈┈
🗣➹share &Join Us
👇🏾👇🏾👇🏾 @freecodecs @freecodecs @freecodecs
┗━ ••• ━ ••━━•••━━━┛
👉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
┈┈┈┈••●◉❖◉●••┈┈┈
🗣➹share &Join Us
👇🏾👇🏾👇🏾 @freecodecs @freecodecs @freecodecs
┗━ ••• ━ ••━━•••━━━┛
AI Programming via @like
👻Who wants full w3school offline version?👻
Offline version is a Web pages you can view without being connected to the Internet. W3school is the best website to learn programming like SQL html/css PHP Python ...... with Exercises👍👍👍👍
😊@freecodecs
Offline version is a Web pages you can view without being connected to the Internet. W3school is the best website to learn programming like SQL html/css PHP Python ...... with Exercises👍👍👍👍
😊@freecodecs
❤2
W3Schools Offline FullTutorial.apk
12.1 MB
W3school offline apk for Android phone
@Freecodecs
@Freecodecs
Quick Sorting Character in Alphabetical Order
AI Programming @freecodecs
As always:
Have a Lit 🔥 Practice Folks 🙌🏽
AI Programming @freecodecs
As always:
Have a Lit 🔥 Practice Folks 🙌🏽