Tutorial corner

Informatica,ETL,oracle,sql/plsql

SQL

sql sample database for practice

Here we are giving  SQL script to create “sql sample database for practice”. We have include SQL statement for important tables like emp/ dept and other improtant table . Table Structure : create table dept( deptno number(2,0), dname varchar2(14), loc varchar2(13), constraint pk_dept primary key (deptno) ); create table emp( empno number(4,0), ename varchar2(10), job […]

Copyright 2015 - Tutorial Corner Frontier Theme