Skip to main content

a2zAspects

a2zAspects can provide Interesting Facts and Information on technical skills like oracle, sql, History

Search This Blog

Home
Contact Us
Privacy Policy
Terms & Conditions

Posts

Oracle Pl/Sql - Questions and Answers 1

on July 19, 2022

+

Get link
Facebook
X
Pinterest
Email
Other Apps

100 Amazing Inventions that have changed our daily life and world in many ways : Part 20

on November 10, 2020

+

Get link
Facebook
X
Pinterest
Email
Other Apps

100 Amazing Inventions that have changed our daily life and world in many ways : Part 19

on November 10, 2020

+

Get link
Facebook
X
Pinterest
Email
Other Apps

100 Amazing Inventions that have changed our daily life and world in many ways : Part 18

on November 09, 2020

+

Get link
Facebook
X
Pinterest
Email
Other Apps

100 Amazing Inventions that have changed our daily life and world in many ways : Part 17

on November 08, 2020

+

Get link
Facebook
X
Pinterest
Email
Other Apps

a2zaspects

Archive

July 20221
November 20208
October 202017
September 20205
August 202010

Labels

History
Interesting Facts
Inventions
java
Natural World
oracel
oracle
PLSQL
Programming
sql

Wars

Show more Show less

Wikipedia Search

Search results

Popular Posts

Oracle Sql - Questions and Answers 2

Oracle Sql - Questions and Answers : Back Next 16. The HR department wants to run reports based on manager. Create a query that prompts the user for a MGR and generates the empno, ename, salary and department for that manager's employees. The HR department wants the ability to sort the report on a selected column. SELECT EMPNO, ENAME, SAL, DEPTNO F...

Oracle Sql - Questions and Answers 3

Oracle Sql - Questions and Answers Back Next 31. Create a query that displays the first eight characters of the employees last names and indicates the amounts of their salaries with asterisks. Each asterisk signifies a thousand dollars. Sort the data in descending order of salary. Label the column EMPLOYEES_...

Oracle Pl/Sql - Questions and Answers 1

Oracle PL/SQL - Questions and Answers 1. Write a program that displays the Netsal(Sal+comm) of an employee entered at run time from EMP table.(Use NVL Function). DECLARE NETSAL NUMBER; BEGIN SELECT NVL(SAL + COMM, SAL) INTO NETSAL FROM EMP WHERE EMPNO = & EMPNO1; DBMS_OUTPUT . PUT_LINE(NETSAL); END ; 2. Write a program that will prompt for a EMPNO,ENAME,SAL. If EMPNO does not exists in EMP table then INSERT the EMPNO,ENAME,SAL into the EMP table else UPDATE ENAME,SAL for that EMPNO. DECLARE EMPNO1 NUMBER; ENAME1 VARCHAR2( 50 ); SAL1 NUMBER; EMPNO_VAL BOOLEAN ; NUM NUMBER; BEGIN EMPNO1 := & EMPNO; ENAME1 := '&ENAME' ; SAL1 := & SAL; SELECT EMPNO INTO NUM FROM EMP WHERE EMPNO = EMPNO1; IF NUM IS NOT NULL THEN ...

Oracle Sql - Questions and Answers 1

Oracle Sql - Questions and Answers ; Back Next 1. Determine the Structure of DEPT Table and its Contents. DESC DEPT; Name Null ? Type ----------------------------------------------------- -------- ------------------------------------ DEPTNO NOT NULL...

Oracle Sql - Questions and Answers 4

Oracle Sql - questions and answers Back Next 45. Write a query for the HR department to produce the addresses of all the departments. Use the EMP and DEPT tables. Show the EMPNO, ENAME, SAL, DNAME and LOC in the output. Use a NATURAL JOIN to produce the results. SELECT EMPNO, ENAME, SAL, DNAME, LOC FROM EMP NATURA...

Oracle Sql - Questions and Answers 5

Oracle Sql - Questions and Answers Back Next 60. Display the ENAME, JOB who are Managers ( Use Exists Operator ) SELECT E.ENAME,E.JOB FROM EMP E WHERE EXISTS ( SELECT E1.ENAME FROM EMP E1 WHERE E.EMPNO = E1.MGR); ENAME JOB ---------- --------- JONES MANAGER BLAKE MANAGER CLARK MANAGER SCOTT ANALYST KING PRESIDENT FORD ANALY...

100 Amazing Inventions that have changed our daily life and world in many ways : Part 9

100 Amazing Inventions 41. What is the importance of DNA finger printing? DNA FINGER PRINTING: In September 1984, Dr. Alec Jeffreys, a geneticist from the university of Leicester in Great Britain was studying hereditary diseases in families when he realized that DNA patterns are unique to each person. DNA Fingerprinting So, he invented the test that is today known as DNA fingerprinting. This test can identify and evaluate the genetic information called DNA or deoxyribonucleic acid, in a person's cells. ...

Thylacine : Why did the Tasmanian wolf became extinct?

T he Tasmanian wolf ( Thylacinus cynocephalus ) is believed to have been extinct since 1936. The Tasmanian wolf commonly known as Tasmanian Tiger and Thylacine. Despite its appearance and its popular name, this animal was not in fact a species of wolf, nor it was a dog, which it also resembled. Thylacine Specimen The Thylacine had become extinct on the Australian mainland before British settlement of the continent, but it survived on the island of Tasmania. The only recorded species of Thylacinus, a genus that resembles the dogs and foxes of the family Canidae, the animal was a predatory marsupial that existed on mainland Australia during the Holocene epoch and observed by Europeans on the island of Tasmania; the ...

100 Amazing Inventions that have changed our daily life and world in many ways : Part 10

100 Amazing Inventions 46. What is MP3 Compression? MP3: Audio files in a normal compact disk can be very large. This is because information on a compact disc is stored in the form of binary digits. MP3 Player MP3 compression reduces the number of bits by taking out unnecessary information. One of the main advantages of MP3 files is that they still retain acceptable audio quality, even after compression, while greatly reducing the size of the file. MP3 files can be downloaded faster than normal files. Moreover, they also take up less space in your computer's memo...

Oracle Sql - Questions and Answers 7

Oracle Sql - Questions and Answers Back Next 96. Create Emp2 table again from Emp table without copying data. CREATE TABLE EMP2 AS ( SELECT * FROM EMP WHERE 1 = 2 ); Table created. 97. Drop Emp2 table. DROP EMP2; Table dropped. 98. Flashback the first Emp2 table that contained data and check your table. ...

Disclaimer
Sitemap

Powered by Blogger

Copyright (c) 2022. All Rights Reserved.