Sabtu, 27 September 2014

RUMUS MEBUAT TABLE EMP 'SISTEM BASIS DATA'

Yanng Posting Unknown di 03.33 0 komentar

SQL> create table emp (empno numeric(4) not null,
  2  ename varchar(10),
  3  job varchar(9),
  4  mgr numeric(4),
  5  hiredate date,
  6  sal numeric(7,2),
  7  comm numeric(7,2),
  8  deptno numeric(2),
  9  constraint pk_emp primary key(empno),
 10  constraint fk_emp_deptno foreign key (deptno) references dept(deptno));

Table created.

SQL>

SQL> create table salgrade (grade numeric(1),
  2  losal numeric(4),
  3  hisal numeric(4),
  4  constraint pk_salgrade primary key(grade));

Table created.


SQL> create table dept (deptno numeric(2),
  2  dname varchar(14),
  3  loc varchar(13));

Table created.

SQL> alter table dept
  2  add primary key (deptno);

Table altered.

Rabu, 19 Maret 2014

Belajar Array ( hari.html )

Yanng Posting Unknown di 02.27 0 komentar
<head>
        <title>Belajar Array</title>
            <script type="text/javascript">
           
            var    nama_hari = new Array("Hari","Senin","Selasa","Rabu","Kamis","Jumat","Sabtu","minggu");
            function hari()
            {
                var angka = document.getElementById("text_hari").value;
                document.getElementById("text_hasil").value = nama_hari[angka];
            }
         
            </script>
    </head>
   
    <body bgcolor=pink>
    Ketik Angka  = <input type=text id=text_hari> <br>
    <input type=button value=Cari onclick='hari();'> <br>
    Hasil Hari= <input type=text id=text_hasil>
    </body>
</html>
Langganan: Komentar (Atom)
 

SI MATA SEMUT Template by Ipietoon Blogger Template | Gift Idea