Tugas Praktikum6 Basis Data

Support Operators

 

Error generated by undened function/type combination

Create of array columns 

Large Objects ( BLOBs)

Subqueriescan replace some joins

Correlated Subquery

NOT IN and Subqueries with NULL values

Customerswho have no orders

IN query rewritten using any and Exists

NOT in query rewritten using ALL and EXISTS

Simulating outer joins

subqueries with update and delete

UPDATE the order_date

Using select with INSERT

Table creation with select

Tugas Praktikum4 Basis Data

Contoh penggunaan Sequence

 

sebelum nya kita buat dulu tabel customer1, 

kemudian di insert dan select dari tabel customer1

The customer table using Serial, 

tabel yang dibuat ialah tabel baru yaitu tabel customer2

create table customer2

insert dan select dari customer2

Combining Two colomn with union

 create table terrestrial_animal

Create table aquatic animal

Combining two tables with union

UNION with duplicates

UNION ALL with duplicate

Reverse Order By dan Where

Nullhandling

sebelumnya buat dulu table nulltest

                                                          values and blank strings
                                                         insert pada nulltest

 

                                               

                                                     
                                                              

                                                   Nullhandling(3)
                                               Using default values
                                           create table account

                            

                                                                     insert dan select pada account

                                    

                                                           

                                                 

                                       melakukan komputasi pada kolom

                                  

                                        mambuat teman baru

                                     

                                Menggunakan AND dan OR


       

  

 Menggunakan AND dan OR(2)

Range Of Values

Like Comparison

-firstname begin with D

CASE Clause

firstname begins with S

Firstname begins with ^.e

CASE Clause(2)

Firstname contains b,B,c, or C

 

Firstname does not contain s or S

Case Clause(3)

firstname ends with n

Firstname contains a non-s character

Case Clause Example

Distinct row

                                               

                                                  Distinct prevents duplicates