a2zAspects

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_AND_THEIR_SALARIES. SELECT RPAD(ENAME, 8 , ' ' ) || ' ' || RPAD( ' ' , SAL / 1000 + 1 , '*' ) AS EMPLOYEES_AND_THEIR_SALARIES FROM EMP ORDER BY SAL DESC ; EMPLOYEES_AND_THEIR_SALARIES ---------------------------------------------------------------------------------------------------- ESWAR ************ KING ***** BLAKE *** SCOTT *** FORD *** JONES ** CLARK ** ALLEN * TURNER * M

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 FROM EMP WHERE MGR =& MANAGER_ID ORDER BY & COLUMNNUMBER; Enter value for manager_id: 7839 Enter value for columnnumber: 1 old 1 : SELECT EMPNO, ENAME, SAL, DEPTNO FROM EMP WHERE MGR =& MANAGER_ID ORDER BY & COLUMNNUMBER new 1 : SELECT EMPNO, ENAME, SAL, DEPTNO FROM EMP WHERE MGR = 7839 ORDER BY 1 EMPNO ENAME SAL DEPTNO ---------- ---------- ---------- ----------

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 ANALYST 6 rows selected. 61. Display the employees who earn less than the least salary of DEPTNO 10. (Use ALL Operator ) SELECT * FROM EMP WHERE SAL < ALL ( SELECT MIN (SAL) FROM EMP WHERE DEPTNO = 10 ); EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO ---------- ---------- --------- ---------- --------- ---------- ---------- ----------

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 NATURAL JOIN DEPT; EMPNO ENAME SAL DNAME LOC ---------- ---------- ---------- -------------- ------------- 7839 KING 5500 ACCOUNTING NEW YORK 7698 BLAKE 3000 SALES CHICAGO 7782 CLARK 2450 ACCOUNTIN

Oracle Sql - Questions and Answers 6

Oracle Sql - Questions and Answers Back Next 75. Create table dept1 as below with following columns : DEPTNO Integer PK, Dname Varchar2(30) Not Null, Loc Varchar2(30) Not Null. CREATE TABLE DEPT1 (DEPTNO NUMBER PRIMARY KEY , DNAME VARCHAR2( 30 ) NOT NULL , LOC VARCHAR2( 30 ) NOT NULL ); Table created. 76. Create table emp1 with the following columns : Empno Integer Pk, Ename Varchar2(20) Not Null, Sal Integer(10, 2) check(sal>5000), mgr Integer FK(Empno), Deptno Integer FK(Deptno). CREATE TABLE EMP1 (EMPNO NUMBER PRIMARY KEY , ENAME VARCHAR2( 20 ) CONSTRAINT CONS_NOT_NULL NOT NULL , SAL NUMBER ( 10 , 2 ) CHECK (SAL > 5000 ), MGR NUMBER CONSTRAINT CONS_MGR REFERENCES EMP(EMPNO), DEPTNO NUMBE

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 NUMBER ( 2 ) DNAME VARCHAR2( 14 ) LOC VARCHAR2( 13 ) 2. Determine the Structure of EMP Table and its Contents. DESC EMP; Name Null ? Type ----------------------------------------------------- -------- ----------------

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. First, By the below command get the " RECYCLEBIN NAME " of the table you want to flashback by using the "DROP TIME" column. SHOW RECYCLEBIN; ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME ---------------- ------------------------------ ------------ ------------------- DEPT1 BIN $ 72 FJF9brQAi7cy9vu3H3pw == $ 0 TABLE 2020 - 10

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 UPDATE EMP SET ENAME = ENAME1, SAL = SAL1 WHERE E

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 species is known as the Tasmanian tiger for the striped markings of the pelage. Although the Thylacine was extinct on mainland Australia, it survi

Morse Code: What is the significance of the invention of Morse Code

T he Morse Code was devised by Samuel Morse, an American painter. It is a system of 'dots and dashes' for sending messages. Each letter or numeral is represented by a unique sequence of dots and dashes. The duration of a dash is three times the duration of a dot. Based on this system, Samuel Morse developed the concept of a single - wire telegraph. The Idea of a Morse Code came to Morse when he was on a ship to New York. There, he met Dr.Charles Jackson of Boston, who was well schooled in electromagnetism. Morse became hooked on the concept of the telegraph. Morse tapped out the first telegraphic message from the Supreme Court Building in Washington to Baltimore. In time, the Morse code would become the primary language of telegraphy in the world.

Disclaimer
Sitemap

Powered by Blogger