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_...

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 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...

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 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 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. Cre...

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. ...

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 ...

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 ...

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. ...

Disclaimer
Sitemap

Powered by Blogger