TechWare

DROP USER SDEV CASCADE; DROP USER STEST CASCADE; DROP USER SPROD CASCADE; DROP USER TDEV CASCADE; DROP USER TTEST CASCADE; DROP USER TPROD CASCADE; CREATE USER SDEV IDENTIFIED by welcome; CREATE USER STEST IDENTIFIED BY welcome; CREATE USER SPROD IDENTIFIED BY welcome; GRANT ALL PRIVILEGES TO SDEV,STEST,SPROD; CREATE USER TDEV IDENTIFIED by welcome; CREATE USER TTEST IDENTIFIED BY welcome; CREATE USER TPROD IDENTIFIED BY welcome; GRANT ALL PRIVILEGES TO TDEV,TTEST,TPROD; CREATE TABLE SDEV.BONUS         (ENAME VARCHAR2(10),          JOB   VARCHAR2(9),          SAL   NUMBER,          COMM  NUMBER); CREATE TABLE SDEV.EMP        (EMPNO NUMBER(4) NOT NULL,         ENAME VARCHAR2(10),         JOB VARCHAR2(9),         MGR NUMBER(4),         HIREDATE DATE,         SAL NUMBER(7, 2),         COMM NUMBER(7, 2),         DEPTNO NUMBER(2)); INSERT INTO SDEV.EMP VALUES         (7369, 'SMITH',  'CLERK',     7902,         TO_DATE('17-DEC-1980', &#

1 ) Write a Query To Delete The Repeted Rows from emp table; SQL>Delete from emp where rowid not in(select min(rowid)from emp group by ename)                 2) TO DISPLAY 5 TO 7 ROWS FROM A TABLE SQL>select ename from emp          where rowid in(select rowid from emp where rownum<=7          minus   select rowid from empi where rownum<5) 3)  DISPLAY  TOP N ROWS FROM TABLE? SQL>SELECT * FROM                 (SELECT *  FROM EMP ORDER BY ENAME DESC)                  WHERE ROWNUM <10; 4) DISPLAY   TOP 3 SALARIES FROM EMP; SQL>SELECT SAL FROM ( SELECT  * FROM EMP ORDER  BY SAL DESC )                    WHERE ROWNUM <4 5) DISPLAY  9th FROM THE EMP TABLE? SQL>SELECT ENAME FROM EMP                 WHERE ROWID=(SELECT ROWID FROM EMP WHERE ROWNUM<=10                 MINUS                 SELECT ROWID FROM EMP WHERE ROWNUM <10)                 select second max salary from emp;                 select max(sal

Logical vs. Physical  The logical design is more conceptual and abstract than the physical design. In the  logical   design ,  you look at the logical relationships among the objects. In the  physical   design , you look at the most effective way of storing and retrieving the objects. Your design should be oriented toward the needs of the end users. End users typically want to perform analysis and look at aggregated data, rather than at individual transactions. Your design is driven primarily by end-user utility, but the end users may not know what they need until they see it. A well-planned design allows for growth and changes as the needs of users change and evolve. Type of Data Modeling? 1) Conceptual Data Model 2) Logical Data Model 3) Physical Data Model Conceptual Data Model - Design Step 1 This is First step for DWH Designing. Conceptual Data Model is the first step in Data Warehouse design. In conceptual data model, very high level relationships