Posts Tagged ‘oracle’

PL/SQL Oracle 9i

Untuk mencoba kode ini, jalankan dari start | Programs|Oracle | Application Development | SQL Plus. Masukkan username =scott dan password =tiger. Untuk administrator, username=system dan password=manager.

1. Select * from dept;
2. select ename, hiredate, sal *12  ANNUAL from emp;
3. select ename, hiredate from emp;
4. select ename from emp where empno=7782;
5. select ename from emp where ename like ‘S%’;
6. select ename, mgr, sal from emp where sal between 1000 and 1600 Read more…