tag:blogger.com,1999:blog-10548089450664583572024-02-18T23:32:32.306-08:00hendrawanAnonymoushttp://www.blogger.com/profile/08492196053582288059noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-1054808945066458357.post-34764997241947478702015-11-12T06:55:00.001-08:002015-11-12T06:55:14.789-08:00TUGAS ORACLE 10G <!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:AllowPNG/>
</o:OfficeDocumentSettings>
</xml><![endif]--><br />
<!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-US</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:EnableOpenTypeKerning/>
<w:DontFlipMirrorIndents/>
<w:OverrideTableStyleHps/>
</w:Compatibility>
<m:mathPr>
<m:mathFont m:val="Cambria Math"/>
<m:brkBin m:val="before"/>
<m:brkBinSub m:val="--"/>
<m:smallFrac m:val="off"/>
<m:dispDef/>
<m:lMargin m:val="0"/>
<m:rMargin m:val="0"/>
<m:defJc m:val="centerGroup"/>
<m:wrapIndent m:val="1440"/>
<m:intLim m:val="subSup"/>
<m:naryLim m:val="undOvr"/>
</m:mathPr></w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="false"
DefSemiHidden="false" DefQFormat="false" DefPriority="99"
LatentStyleCount="371">
<w:LsdException Locked="false" Priority="0" QFormat="true" Name="Normal"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 1"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 2"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 3"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 4"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 5"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 6"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 7"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 8"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 9"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 9"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 1"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 2"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 3"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 4"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 5"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 6"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 7"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 8"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 9"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footnote text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation text"/>
<w:LsdException Locked="false" Priority="0" SemiHidden="true"
UnhideWhenUsed="true" Name="header"/>
<w:LsdException Locked="false" Priority="0" SemiHidden="true"
UnhideWhenUsed="true" Name="footer"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index heading"/>
<w:LsdException Locked="false" Priority="35" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="caption"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="table of figures"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="envelope address"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="envelope return"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footnote reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="line number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="page number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="endnote reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="endnote text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="table of authorities"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="macro"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="toa heading"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 5"/>
<w:LsdException Locked="false" Priority="10" QFormat="true" Name="Title"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Closing"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Signature"/>
<w:LsdException Locked="false" Priority="1" SemiHidden="true"
UnhideWhenUsed="true" Name="Default Paragraph Font"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Message Header"/>
<w:LsdException Locked="false" Priority="11" QFormat="true" Name="Subtitle"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Salutation"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Date"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text First Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text First Indent 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Note Heading"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Block Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Hyperlink"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="FollowedHyperlink"/>
<w:LsdException Locked="false" Priority="22" QFormat="true" Name="Strong"/>
<w:LsdException Locked="false" Priority="20" QFormat="true" Name="Emphasis"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Document Map"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Plain Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="E-mail Signature"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Top of Form"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Bottom of Form"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal (Web)"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Acronym"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Address"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Cite"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Code"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Definition"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Keyboard"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Preformatted"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Sample"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Typewriter"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Variable"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal Table"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation subject"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="No List"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Contemporary"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Elegant"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Professional"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Subtle 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Subtle 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Balloon Text"/>
<w:LsdException Locked="false" Priority="39" Name="Table Grid"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Theme"/>
<w:LsdException Locked="false" SemiHidden="true" Name="Placeholder Text"/>
<w:LsdException Locked="false" Priority="1" QFormat="true" Name="No Spacing"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading"/>
<w:LsdException Locked="false" Priority="61" Name="Light List"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 1"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 1"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 1"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 1"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 1"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 1"/>
<w:LsdException Locked="false" SemiHidden="true" Name="Revision"/>
<w:LsdException Locked="false" Priority="34" QFormat="true"
Name="List Paragraph"/>
<w:LsdException Locked="false" Priority="29" QFormat="true" Name="Quote"/>
<w:LsdException Locked="false" Priority="30" QFormat="true"
Name="Intense Quote"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 1"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 1"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 1"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 1"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 1"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 1"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 1"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 1"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 2"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 2"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 2"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 2"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 2"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 2"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 2"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 2"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 2"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 2"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 2"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 2"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 2"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 2"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 3"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 3"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 3"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 3"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 3"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 3"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 3"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 3"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 3"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 3"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 3"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 3"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 3"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 3"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 4"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 4"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 4"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 4"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 4"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 4"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 4"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 4"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 4"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 4"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 4"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 4"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 4"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 4"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 5"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 5"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 5"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 5"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 5"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 5"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 5"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 5"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 5"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 5"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 5"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 5"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 5"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 5"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 6"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 6"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 6"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 6"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 6"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 6"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 6"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 6"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 6"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 6"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 6"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 6"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 6"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 6"/>
<w:LsdException Locked="false" Priority="19" QFormat="true"
Name="Subtle Emphasis"/>
<w:LsdException Locked="false" Priority="21" QFormat="true"
Name="Intense Emphasis"/>
<w:LsdException Locked="false" Priority="31" QFormat="true"
Name="Subtle Reference"/>
<w:LsdException Locked="false" Priority="32" QFormat="true"
Name="Intense Reference"/>
<w:LsdException Locked="false" Priority="33" QFormat="true" Name="Book Title"/>
<w:LsdException Locked="false" Priority="37" SemiHidden="true"
UnhideWhenUsed="true" Name="Bibliography"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="TOC Heading"/>
<w:LsdException Locked="false" Priority="41" Name="Plain Table 1"/>
<w:LsdException Locked="false" Priority="42" Name="Plain Table 2"/>
<w:LsdException Locked="false" Priority="43" Name="Plain Table 3"/>
<w:LsdException Locked="false" Priority="44" Name="Plain Table 4"/>
<w:LsdException Locked="false" Priority="45" Name="Plain Table 5"/>
<w:LsdException Locked="false" Priority="40" Name="Grid Table Light"/>
<w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark"/>
<w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful"/>
<w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 1"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 1"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 1"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 1"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 1"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 2"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 2"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 2"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 2"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 2"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 3"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 3"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 3"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 3"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 3"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 4"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 4"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 4"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 4"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 4"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 5"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 5"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 5"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 5"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 5"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 6"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 6"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 6"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 6"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 6"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="46" Name="List Table 1 Light"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark"/>
<w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful"/>
<w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 1"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 1"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 1"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 1"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 1"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 2"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 2"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 2"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 2"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 2"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 3"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 3"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 3"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 3"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 3"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 4"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 4"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 4"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 4"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 4"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 5"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 5"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 5"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 5"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 5"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 6"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 6"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 6"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 6"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 6"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 6"/>
</w:LatentStyles>
</xml><![endif]--><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin-top:0cm;
mso-para-margin-right:0cm;
mso-para-margin-bottom:8.0pt;
mso-para-margin-left:0cm;
line-height:107%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;}
</style>
<![endif]-->
<br />
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">Nama : Ahmad Hendrawan </span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">NPM :1143003</span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">Kelas :D3TI2B</span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">1.Connect to Oracle, dengan format
USER:system, PASSWORD:sesuai yang kita buat.</span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">2.CREATE USER RumahSakit IDENTIFIED
BY bebas123</span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">3.Grant connect, resource to
RumahSakit;</span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">4.CREATE TABLE Dokter (<br />
KdDokter VARCHAR2(5)<br />
CONSTRAINT Dokter_pk PRIMARY KEY,<br />
NmDokter VARCHAR2(40) NOT NULL,<br />
Spesialisasi VARCHAR2 (2) NOT NULL,<br />
Golongan INTEGER NOT NULL,<br />
supervisor VARCHAR2(5)<br />
);</span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">kemudian akan muncul tabel created. </span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">5.kemudian input,</span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"> INSERT INTO Dokter
(KdDokter, NmDokter, Spesialisasi, Golongan, Supervisor)<br />
VALUES ('DR009', 'Opik','UM',3);</span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3O8azcv4G3P18fkgu0xON_9Kc2vLVJ4Gd0e413skMlQ2smsICcyuHrktKmH-qxlLqvE1IH1oApLml4XNZZdREXpaA7GJz0zySlmlW3p22EIef6q_28Wg1jPjcrsfwYnlO0nNNXQaNzfY/s1600/TABEL+DOKTER.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="133" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3O8azcv4G3P18fkgu0xON_9Kc2vLVJ4Gd0e413skMlQ2smsICcyuHrktKmH-qxlLqvE1IH1oApLml4XNZZdREXpaA7GJz0zySlmlW3p22EIef6q_28Wg1jPjcrsfwYnlO0nNNXQaNzfY/s320/TABEL+DOKTER.png" width="320" /></a></div>
<br />
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">6. CREATE TABLE Pasien (<br />
KdPasien VARCHAR2(5)<br />
CONSTRAINT Pasien_pk PRIMARY KEY,<br />
NmPasien VARCHAR2(20) NOT NULL,<br />
JenKel VARCHAR2 (1) NOT NULL,<br />
Umur INTEGER NOT NULL<br />
);</span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">7.Lakukan penginputan</span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"> INSERT INTO Pasien
(KdPasien, NmPasien, JenKel, Umur)<br />
VALUES ('PS010', 'Merry Resh','W',19);</span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirGkCu8CIT64bZ1jaB47xlTyEzlIeAenrCrfPLNZtOmZc3desQbiBtx1eYMYBPXqlkrx1nBJu8IHilZTsTYS5QsJ8ZZkkxFIkSWAytovw4SSg2UVhl4CE9T7IgfS5wREHi8HTLBTiRT8g/s1600/TABEL+PASIEN.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="257" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirGkCu8CIT64bZ1jaB47xlTyEzlIeAenrCrfPLNZtOmZc3desQbiBtx1eYMYBPXqlkrx1nBJu8IHilZTsTYS5QsJ8ZZkkxFIkSWAytovw4SSg2UVhl4CE9T7IgfS5wREHi8HTLBTiRT8g/s320/TABEL+PASIEN.png" width="320" /></a></div>
<br />
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">8. CREATE TABLE TrKlinik (<br />
KdTransaksi VARCHAR2(5)<br />
CONSTRAINT TrKlinik_pk PRIMARY KEY,<br />
TglPeriksa DATE NOT NULL,<br />
KdDokter VARCHAR2(5)<br />
CONSTRAINT TrKlinik_fk_Dokter<br />
REFERENCES Dokter(KdDokter),<br />
KdPasien VARCHAR2(5)<br />
CONSTRAINT TrKlinik_fk_Pasien<br />
REFERENCES Pasien(KdPasien),<br />
Biaya INTEGER<br />
);</span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">9.Lakukan input lagi</span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"> INSERT INTO TrKlinik
(KdTransaksi, TglPeriksa, KdDokter, KdPasien, Biaya)<br />
VALUES ('TR003', '10-DEC-2007', 'DR002','PS002',35000);</span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhxU7oOojgPvCrIjXTthq8K3SWDLjqZrIobv3gjvZrY7Tq1fmK7RFO0Oawuzfga_0CxgY91wSsmJ3x_YEgkxBrk0hHHpT-_wrr9LliS3-mhGb07n1Fg6-ZexlJ4pZCI5uazcRpyC2kkaNs/s1600/TABEL+TRKLINIK.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhxU7oOojgPvCrIjXTthq8K3SWDLjqZrIobv3gjvZrY7Tq1fmK7RFO0Oawuzfga_0CxgY91wSsmJ3x_YEgkxBrk0hHHpT-_wrr9LliS3-mhGb07n1Fg6-ZexlJ4pZCI5uazcRpyC2kkaNs/s320/TABEL+TRKLINIK.png" width="270" /></a></div>
<br />
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">soal-soal</span></div>
<div class="MsoNormalCxSpMiddle" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-add-space: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">Buat
query untuk menampilkan informasi sebagai </span></div>
<div class="MsoNormalCxSpMiddle" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-add-space: auto;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; tab-stops: list 18.0pt; text-align: justify; text-indent: -18.0pt;">
<span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";">1.</span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 7.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";"> </span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">T</span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";">ampilkan kode
dokter, nama dokter dan spesialisasi dari dokter yang memiliki golongan </span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">2.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; tab-stops: list 18.0pt; text-align: justify; text-indent: -18.0pt;">
<span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";">2.</span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 7.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";"> </span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">T</span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";">ampilkan data
pasien anak-anak (umurnya dibawah atau sama dengan 1</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">2</span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";">)</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; tab-stops: list 18.0pt; text-align: justify; text-indent: -18.0pt;">
<span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";">3.</span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 7.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";"> </span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">T</span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";">ampilkan pasien
yang memiliki umur diantara </span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">1</span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";">0 sampai dengan
</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">25</span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";"> diurutkan berdasarkan abjad yang
terbesar (dari huruf Z sampai ke A)</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; tab-stops: list 18.0pt; text-align: justify; text-indent: -18.0pt;">
<span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";">4.</span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 7.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";"> </span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">B</span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";">erapa jumlah
pasien berjenis kelamin W yang berumur diatas 1</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">5</span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";"> tahun</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; tab-stops: list 18.0pt; text-align: justify; text-indent: -18.0pt;">
<span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";">5.</span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 7.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";"> </span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">B</span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";">erapa jumlah
pasien berjenis kelamin </span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">L</span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";"> yang berumur d</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">ibawah 17</span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";"> tahun</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; tab-stops: list 18.0pt; text-align: justify; text-indent: -18.0pt;">
<span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";">6.</span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 7.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";"> </span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">T</span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";">ampilkan kode
pasien yang diperiksa tanggal 12/12/2007 diurutkan secara </span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">Descending.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; tab-stops: list 18.0pt; text-align: justify; text-indent: -18.0pt;">
<span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";">7.</span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 7.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";"> </span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";">Hitung total biaya yang dibayarkan oleh pasien yang
memiliki kode ‘PS00</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">2</span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";">’</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; tab-stops: list 18.0pt; text-align: justify; text-indent: -18.0pt;">
<span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";">8.</span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 7.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";"> </span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";">Hitung total biaya yang dibayarkan oleh masing-masing
pasien.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; tab-stops: list 18.0pt; text-align: justify; text-indent: -18.0pt;">
<span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";">9.</span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 7.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";"> </span><span lang="IN" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-ansi-language: IN; mso-fareast-font-family: "Times New Roman";">Hitung rata-rata biaya yang diterima oleh masing-masing
dokter.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"> </span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">jawab</span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">1. select kddokter, nmdokter,
spesialisasi, golongan<br />
from dokter<br />
where golongan=2;</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6NnvIOnCilgBpGUPhbe7cYsuQZorWhYOspR_T7wToV4atl03jRwX3wrx1m5CTq5ZOLhWOGr76tP0ONhmyeJY-1oTLjTsIldr5SaTc6jmeHcZFvB8pyuA024AR98EpNOjlzOLQD3pQ3ek/s1600/NO+1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="79" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6NnvIOnCilgBpGUPhbe7cYsuQZorWhYOspR_T7wToV4atl03jRwX3wrx1m5CTq5ZOLhWOGr76tP0ONhmyeJY-1oTLjTsIldr5SaTc6jmeHcZFvB8pyuA024AR98EpNOjlzOLQD3pQ3ek/s320/NO+1.png" width="320" /></a></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">2. select * from pasien<br />
where umur<=12;</span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZLQ6fnuhOtNZuFBo42LHm1XSaj8lEzdZs0b2160dA-u9tjsfFAQ8HXC7I3XG6KwM83BxKtsS81vqSYIlYF8zsDnYijF3DL0vRgxhF2ixF_Ww94xZ7pTfgq83GYxlSY1KjEqrrwJaFRZ4/s1600/NO+2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="119" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZLQ6fnuhOtNZuFBo42LHm1XSaj8lEzdZs0b2160dA-u9tjsfFAQ8HXC7I3XG6KwM83BxKtsS81vqSYIlYF8zsDnYijF3DL0vRgxhF2ixF_Ww94xZ7pTfgq83GYxlSY1KjEqrrwJaFRZ4/s320/NO+2.png" width="320" /></a></div>
<br />
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">3. select * from pasien<br />
where umur between 10 and 25<br />
order by nmpasien desc;</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipI9f8PpNQHTcQrN6ev-qhJNg5oNQB4fJpi-0b8CrDW4EulI1DeLoCr0FwnP8UlXOXtJQ_GxjsHIHS0_kDsX_AdOmcGaEBgkK33-ipY1HvHVsYmuo1wCVpR5JnCprE23ztysK8qyMBlCs/s1600/NO+3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipI9f8PpNQHTcQrN6ev-qhJNg5oNQB4fJpi-0b8CrDW4EulI1DeLoCr0FwnP8UlXOXtJQ_GxjsHIHS0_kDsX_AdOmcGaEBgkK33-ipY1HvHVsYmuo1wCVpR5JnCprE23ztysK8qyMBlCs/s1600/NO+3.png" /></a></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">4. select count(*) from pasien<br />
where jenkel='W' and umur>15; </span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibG5Y8FR7RC2QgSk6NnstHZUCKFE6fvh5-sovDnhu8ZbFhnPXycsNOU3pnTHA_XPpJIBX38oz0KEweYd-6vHnguXk9Bc0R_ZtXwPwN-FmHXS5ojAnXJw8jlDTbOPs1jTzm2m8-1NDT0Ng/s1600/NO+4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibG5Y8FR7RC2QgSk6NnstHZUCKFE6fvh5-sovDnhu8ZbFhnPXycsNOU3pnTHA_XPpJIBX38oz0KEweYd-6vHnguXk9Bc0R_ZtXwPwN-FmHXS5ojAnXJw8jlDTbOPs1jTzm2m8-1NDT0Ng/s1600/NO+4.png" /></a></div>
<br />
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">5. select count(*) from pasien<br />
where jenkel='L' and umur<17;</span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh86dpVMqOkhRhklAepsMRsHIlxikl7Sm4hiZ09lNSfF2dbUEH8hMoDoo4PhXRYYU2vqFWpp6v4FxTy3Ukb5zttlZcRQEitmixvPclmB0CWYAhXSgeaFsB9yUA_ACKfoVHMEB11hEmyrwU/s1600/NO+5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh86dpVMqOkhRhklAepsMRsHIlxikl7Sm4hiZ09lNSfF2dbUEH8hMoDoo4PhXRYYU2vqFWpp6v4FxTy3Ukb5zttlZcRQEitmixvPclmB0CWYAhXSgeaFsB9yUA_ACKfoVHMEB11hEmyrwU/s1600/NO+5.png" /></a></div>
<br />
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">6. select kdpasien from
trklinik<br />
where tglperiksa='12-DEC-2007'<br />
order by kdpasien desc;</span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOVaE55VseWygbOUgKk2fnEwGohQlv_wgMiWfAgzmmSBzugFFh6qoYiTwR-kkaezqyoHQ88hq9coc01G8iR9uG4MpRyw_zegRfVqCxbxc_ekpRAXS0G4Z_6TwAWRYW4zZUAzYu2v74Azg/s1600/NO+6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOVaE55VseWygbOUgKk2fnEwGohQlv_wgMiWfAgzmmSBzugFFh6qoYiTwR-kkaezqyoHQ88hq9coc01G8iR9uG4MpRyw_zegRfVqCxbxc_ekpRAXS0G4Z_6TwAWRYW4zZUAzYu2v74Azg/s1600/NO+6.png" /></a></div>
<br />
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">7. select sum(biaya) from
trklinik<br />
where kdpasien='PS002';</span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiBW2EFqEKsgMZ4-E3qal6vDDPzIVmPqXc2k-kjwRbsFwaNL-Pg2MmzGfA0dVUzLRUC4nE_HVsznKEqagMtntI-qYQWAfXqJj34w-3UX9Zud6-XnSpoSAeTVsq6PotSeFnLRtpmwZZdrpY/s1600/NO+7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiBW2EFqEKsgMZ4-E3qal6vDDPzIVmPqXc2k-kjwRbsFwaNL-Pg2MmzGfA0dVUzLRUC4nE_HVsznKEqagMtntI-qYQWAfXqJj34w-3UX9Zud6-XnSpoSAeTVsq6PotSeFnLRtpmwZZdrpY/s1600/NO+7.png" /></a></div>
<br />
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">8. select kdpasien, sum(biaya) from
trklinik<br />
group by kdpasien;</span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaz9xBtW1SIGkIwte1T4-pLDKNHNBXSDNUaUTo4a3YZN275mdFPgMMhfjofizf_-oxHLp4-LrFppikL57zl7P0gq92GHuut_Fij_sqqyYB3XD3lAgOEoMZGvhx2m4N-n2WWy1aJoF_a0s/s1600/NO+8.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="218" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaz9xBtW1SIGkIwte1T4-pLDKNHNBXSDNUaUTo4a3YZN275mdFPgMMhfjofizf_-oxHLp4-LrFppikL57zl7P0gq92GHuut_Fij_sqqyYB3XD3lAgOEoMZGvhx2m4N-n2WWy1aJoF_a0s/s320/NO+8.png" width="320" /></a></div>
<br />
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">9. select kddokter, avg(biaya) from
trklinik<br />
group by kddokter;</span></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZsK-sAzMkY5McmX59jIx0t7uxcNItqfKv_Tnx7mMLJpRXVc1b4DzxhaB2tpgfUHahhRoS9u4Q8jHUHq0N5S32NtdOPrgs0PCcDC3wJgPJ3PHE5OpTGN3wrU5Ycr0ymUBbNniLL9t-vWI/s1600/N0+9.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="213" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZsK-sAzMkY5McmX59jIx0t7uxcNItqfKv_Tnx7mMLJpRXVc1b4DzxhaB2tpgfUHahhRoS9u4Q8jHUHq0N5S32NtdOPrgs0PCcDC3wJgPJ3PHE5OpTGN3wrU5Ycr0ymUBbNniLL9t-vWI/s320/N0+9.png" width="320" /></a></div>
<br />
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">
<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">sekian dan terima kasih </span></div>
<div class="MsoNormal">
<br /></div>
Anonymoushttp://www.blogger.com/profile/08492196053582288059noreply@blogger.com0tag:blogger.com,1999:blog-1054808945066458357.post-40987822815745880682015-04-07T08:44:00.003-07:002015-04-07T08:44:53.036-07:00DATABASE KOPRASIDATABASE KOPRASI<br />
NAMA = AHMAD HENDRAWAN<br />
KELAS = D3 TI 1B<br />
NPM = 1143003<br />
<br />
<br />
<br />
1.BENTUK CDM DARI DATA KOPRASI <br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjf9W9gMOAiJmC8EBRyOi3ODqOVjtpwzE_5_GWv2xPhuR0fa7dNKlkmO_E2OROGxj6a9WQeYtn5jvrV0MTWzOay3R58e0iljav0DYmdVZp4k8cRNbMDtvKTr9pRaibp4eoJtcKD9f9lgus/s1600/2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjf9W9gMOAiJmC8EBRyOi3ODqOVjtpwzE_5_GWv2xPhuR0fa7dNKlkmO_E2OROGxj6a9WQeYtn5jvrV0MTWzOay3R58e0iljav0DYmdVZp4k8cRNbMDtvKTr9pRaibp4eoJtcKD9f9lgus/s1600/2.jpg" height="165" width="320" /></a></div>
<br />
2.BENTUK PDM DARI DATA KOPRASI<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLaU3OCCnUhIxYFZjCMFIVjA8g1k7pxZneT9XLaosyj0sLl4Mrkhu2ATsJmApq8TKvK9GUr4KHVyIg1X68vu-yqPd01kp2xV4nrcCvHGLGanzRM-FQiKgMM81OvaVEpHcugJ3cmXu4ltc/s1600/1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLaU3OCCnUhIxYFZjCMFIVjA8g1k7pxZneT9XLaosyj0sLl4Mrkhu2ATsJmApq8TKvK9GUr4KHVyIg1X68vu-yqPd01kp2xV4nrcCvHGLGanzRM-FQiKgMM81OvaVEpHcugJ3cmXu4ltc/s1600/1.jpg" height="166" width="320" /></a></div>
3.UNTUK MENGETAHUI NILAI TERKECIL DARI SEBUAH KOLOM<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhzks1Te2p7s7khk-3CoYJDayB7wn6abYkWTyclZ3sIl-3CwO-VQaIQvvFI1zExPDy9K2acueRd6FKq4LgRsibYGd2gNnT45pOV9_WDi7h59-81O2-MLe_k_54KD5mMORToIbrcoqbO03o/s1600/UNTUK+MENGETAHUI+JUMLAH+PINJAMAN+TEKECIL.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhzks1Te2p7s7khk-3CoYJDayB7wn6abYkWTyclZ3sIl-3CwO-VQaIQvvFI1zExPDy9K2acueRd6FKq4LgRsibYGd2gNnT45pOV9_WDi7h59-81O2-MLe_k_54KD5mMORToIbrcoqbO03o/s1600/UNTUK+MENGETAHUI+JUMLAH+PINJAMAN+TEKECIL.jpg" height="109" width="320" /></a></div>
4.UNTUK MENGETAHUI NILAI TERBESAR DARI SEBUAH KOLOM<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZbfFcnZk9T3Q_kxN6xzj77egE03Kb92HMDbQRiEVHdgeT3CgBX0bziP6ZJDv3HvlN8TpFGh5GZ-axfd5pURqj-5vtbhh0Nuk5_pV81DTH3Au3INB6xPe_UUeQhu9QChjD-kDFuOsnVWQ/s1600/TERBANYAK.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZbfFcnZk9T3Q_kxN6xzj77egE03Kb92HMDbQRiEVHdgeT3CgBX0bziP6ZJDv3HvlN8TpFGh5GZ-axfd5pURqj-5vtbhh0Nuk5_pV81DTH3Au3INB6xPe_UUeQhu9QChjD-kDFuOsnVWQ/s1600/TERBANYAK.jpg" height="118" width="320" /></a></div>
5.UNTUK MENGETAHUI RENTAN WAKTU<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3IVHz40irT5DIA8nVZat24Y-8Q34WctF22VCfTRdQKE3qyVmq8TPWIdV5OIaTlkg1GRxakkAezRi3xYjA-BYv-ovMiPSxRhWlfpgbVaRg5HpLmfDE4R47m7UNJI49Qbw4xMAB9_S_PY0/s1600/RENTAN+WAKTU.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3IVHz40irT5DIA8nVZat24Y-8Q34WctF22VCfTRdQKE3qyVmq8TPWIdV5OIaTlkg1GRxakkAezRi3xYjA-BYv-ovMiPSxRhWlfpgbVaRg5HpLmfDE4R47m7UNJI49Qbw4xMAB9_S_PY0/s1600/RENTAN+WAKTU.jpg" height="114" width="320" /></a></div>
<br />
<br />Anonymoushttp://www.blogger.com/profile/08492196053582288059noreply@blogger.com0tag:blogger.com,1999:blog-1054808945066458357.post-35722142140275831552015-03-30T21:03:00.002-07:002015-03-30T21:03:35.453-07:00TUGAS BASIS DATA ( KUMPULAN SYNTAX)<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:AllowPNG/>
</o:OfficeDocumentSettings>
</xml><![endif]--><br />
<!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-US</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:EnableOpenTypeKerning/>
<w:DontFlipMirrorIndents/>
<w:OverrideTableStyleHps/>
</w:Compatibility>
<m:mathPr>
<m:mathFont m:val="Cambria Math"/>
<m:brkBin m:val="before"/>
<m:brkBinSub m:val="--"/>
<m:smallFrac m:val="off"/>
<m:dispDef/>
<m:lMargin m:val="0"/>
<m:rMargin m:val="0"/>
<m:defJc m:val="centerGroup"/>
<m:wrapIndent m:val="1440"/>
<m:intLim m:val="subSup"/>
<m:naryLim m:val="undOvr"/>
</m:mathPr></w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="false"
DefSemiHidden="false" DefQFormat="false" DefPriority="99"
LatentStyleCount="371">
<w:LsdException Locked="false" Priority="0" QFormat="true" Name="Normal"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 1"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 2"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 3"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 4"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 5"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 6"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 7"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 8"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 9"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 9"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 1"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 2"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 3"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 4"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 5"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 6"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 7"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 8"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 9"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footnote text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="header"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footer"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index heading"/>
<w:LsdException Locked="false" Priority="35" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="caption"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="table of figures"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="envelope address"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="envelope return"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footnote reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="line number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="page number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="endnote reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="endnote text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="table of authorities"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="macro"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="toa heading"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 5"/>
<w:LsdException Locked="false" Priority="10" QFormat="true" Name="Title"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Closing"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Signature"/>
<w:LsdException Locked="false" Priority="1" SemiHidden="true"
UnhideWhenUsed="true" Name="Default Paragraph Font"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Message Header"/>
<w:LsdException Locked="false" Priority="11" QFormat="true" Name="Subtitle"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Salutation"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Date"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text First Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text First Indent 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Note Heading"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Block Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Hyperlink"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="FollowedHyperlink"/>
<w:LsdException Locked="false" Priority="22" QFormat="true" Name="Strong"/>
<w:LsdException Locked="false" Priority="20" QFormat="true" Name="Emphasis"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Document Map"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Plain Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="E-mail Signature"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Top of Form"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Bottom of Form"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal (Web)"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Acronym"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Address"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Cite"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Code"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Definition"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Keyboard"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Preformatted"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Sample"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Typewriter"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Variable"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal Table"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation subject"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="No List"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Contemporary"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Elegant"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Professional"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Subtle 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Subtle 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Balloon Text"/>
<w:LsdException Locked="false" Priority="39" Name="Table Grid"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Theme"/>
<w:LsdException Locked="false" SemiHidden="true" Name="Placeholder Text"/>
<w:LsdException Locked="false" Priority="1" QFormat="true" Name="No Spacing"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading"/>
<w:LsdException Locked="false" Priority="61" Name="Light List"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 1"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 1"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 1"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 1"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 1"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 1"/>
<w:LsdException Locked="false" SemiHidden="true" Name="Revision"/>
<w:LsdException Locked="false" Priority="34" QFormat="true"
Name="List Paragraph"/>
<w:LsdException Locked="false" Priority="29" QFormat="true" Name="Quote"/>
<w:LsdException Locked="false" Priority="30" QFormat="true"
Name="Intense Quote"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 1"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 1"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 1"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 1"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 1"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 1"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 1"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 1"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 2"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 2"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 2"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 2"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 2"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 2"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 2"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 2"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 2"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 2"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 2"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 2"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 2"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 2"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 3"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 3"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 3"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 3"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 3"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 3"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 3"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 3"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 3"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 3"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 3"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 3"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 3"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 3"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 4"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 4"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 4"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 4"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 4"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 4"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 4"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 4"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 4"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 4"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 4"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 4"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 4"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 4"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 5"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 5"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 5"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 5"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 5"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 5"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 5"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 5"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 5"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 5"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 5"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 5"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 5"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 5"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 6"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 6"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 6"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 6"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 6"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 6"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 6"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 6"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 6"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 6"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 6"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 6"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 6"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 6"/>
<w:LsdException Locked="false" Priority="19" QFormat="true"
Name="Subtle Emphasis"/>
<w:LsdException Locked="false" Priority="21" QFormat="true"
Name="Intense Emphasis"/>
<w:LsdException Locked="false" Priority="31" QFormat="true"
Name="Subtle Reference"/>
<w:LsdException Locked="false" Priority="32" QFormat="true"
Name="Intense Reference"/>
<w:LsdException Locked="false" Priority="33" QFormat="true" Name="Book Title"/>
<w:LsdException Locked="false" Priority="37" SemiHidden="true"
UnhideWhenUsed="true" Name="Bibliography"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="TOC Heading"/>
<w:LsdException Locked="false" Priority="41" Name="Plain Table 1"/>
<w:LsdException Locked="false" Priority="42" Name="Plain Table 2"/>
<w:LsdException Locked="false" Priority="43" Name="Plain Table 3"/>
<w:LsdException Locked="false" Priority="44" Name="Plain Table 4"/>
<w:LsdException Locked="false" Priority="45" Name="Plain Table 5"/>
<w:LsdException Locked="false" Priority="40" Name="Grid Table Light"/>
<w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark"/>
<w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful"/>
<w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 1"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 1"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 1"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 1"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 1"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 2"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 2"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 2"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 2"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 2"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 3"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 3"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 3"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 3"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 3"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 4"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 4"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 4"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 4"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 4"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 5"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 5"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 5"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 5"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 5"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 6"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 6"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 6"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 6"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 6"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="46" Name="List Table 1 Light"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark"/>
<w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful"/>
<w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 1"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 1"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 1"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 1"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 1"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 2"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 2"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 2"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 2"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 2"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 3"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 3"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 3"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 3"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 3"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 4"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 4"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 4"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 4"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 4"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 5"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 5"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 5"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 5"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 5"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 6"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 6"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 6"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 6"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 6"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 6"/>
</w:LatentStyles>
</xml><![endif]--><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin-top:0cm;
mso-para-margin-right:0cm;
mso-para-margin-bottom:8.0pt;
mso-para-margin-left:0cm;
line-height:107%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-ansi-language:EN-US;
mso-fareast-language:EN-US;}
</style>
<![endif]-->
<br />
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3;">
<a href="https://www.blogger.com/null" name="uds-search-results"></a><a href="https://www.blogger.com/null" name="6439884487835460995"></a><b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 13.5pt; mso-fareast-font-family: "Times New Roman";"></span></b><b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">NAMA = AHMAD HENDRAWAN</span></b></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3;">
<b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">KELAS = D3 TI 1B</span></b></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3;">
<b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">NPM = 1143003</span></b></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3;">
</div>
<div class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 3;">
<b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">Create
Database</span></b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;">
<span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">Digunakan untuk membuat database
baru.<br />
Syntax dasar:<br />
<br />
CREATE DATABASE database_nama<br />
Contoh:<br />
<br />
CREATE DATABASE databaseku</span></div>
<b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"> Create
Table</span></b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"></span>
<br />
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;">
<span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">Digunakan untuk membuat tabel data baru
dalam sebuah database.<br />
Syntax dasar:<br />
<br />
CREATE TABLE<br />
(<br />
Column_name1 table_nama data_type<br />
Column_name2 table_nama data_type<br />
Column_name3 table_nama data_type<br />
<br />
)<br />
<br />
Contoh:<br />
<br />
CREATE TABLE bukutamu<br />
(<br />
Id int,<br />
Nama varchar (255),<br />
Email varchar(50),<br />
Kota varchar(255)<br />
<br />
)</span><b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"> </span></b></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;">
<b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">Select</span></b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"></span>
</div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt;">
<span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">Digunakan untuk memilih data dari
table database.<br />
Syntax dasar:<br />
SELECT column_name(s)<br />
FROM table_name<br />
Atau<br />
SELECT * FROM table_name<br />
Contoh 1:<br />
SELECT nama,email FROM bukutamu<br />
Contoh 2:<br />
<br />
SELECT * FROM bukutamu</span><b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"> </span></b></div>
<br />
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;">
<b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">Between</span></b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"></span>
</div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;">
<span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">Digunakan untuk menentukan jangkauan
pencarian.<br />
Syntax dasar:<br />
<br />
SELECT column_name(s)<br />
FROM table_name<br />
WHERE column_name<br />
BETWEEN value1 AND value2<br />
<br />
Contoh :<br />
<br />
SELECT * FROM bukutamu <br />
WHERE id<br />
BETWEEN 5 and 15<br />
<br />
Keterangan :<br />
<br />
Contoh di atas digunakan untuk mencari data yang memiliki nomor id antara 5 dan
15.</span><b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"> </span></b></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt;">
<b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">Where</span></b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"></span>
</div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;">
<span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">Digunakan untuk memfilter data pada
perintah Select <br />
Syntax dasar:<br />
<br />
SELECT column name(s)<br />
FROM table_name<br />
WHERE column_name operator value<br />
<br />
Contoh:<br />
<br />
SELECT * FROM bukutamu<br />
WHERE kota=’YOGYAKARTA’</span><b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"> </span></b></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;">
<b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">Order
By</span></b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"></span>
</div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;">
<span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">Digunakan untuk mengurutkan data
berdasarkan kolom (field) tertentu. Secara default, urutan tersusun secara
ascending (urut kecil ke besar). Anda dapat mengubahnya menjadi descending
(urut besar ke kecil) dengan menambahkan perintah DESC.<br />
<br />
Syntax dasar:<br />
<br />
SELECT column_name(s)<br />
FROM table_name<br />
ORDER BY column_name(s) ASC|DESC<br />
<br />
Contoh 1:<br />
<br />
SELECT * FROM bukutamu<br />
ORDER BY nama <br />
<br />
Contoh 2:<br />
<br />
SELECT * FROM bukutamu<br />
ORDER BY id DESC</span><b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"> </span></b></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;">
<b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">Insert
Into</span></b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"></span>
</div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;">
<span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">Digunakan untuk menambahkan data
baru di tabel database.<br />
Syntax dasar :<br />
<br />
INSERT INTO table_name<br />
VALUES (value1,value2,value3, . . .)<br />
Atau<br />
INSERT INTO table_name (column1,column2,column3, . . .)<br />
VALUES (value1,value2,value3, . . .)<br />
Contoh 1:<br />
<br />
INSERT INTO bukutamu<br />
VALUES (1,’ahmad’,’hendrawan1795@gmail.com’,’cianjur’)<br />
Contoh 2:<br />
INSERT INTO bukutamu (id,nama,email,kota)<br />
VALUES </span><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">(1,’ahmad’,’hendrawan1795@gmail.com’,’cianjur’)</span><b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"></span></b></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;">
<b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"> </span></b><b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">Delete</span></b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"></span>
<span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"> </span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;">
<span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">Digunakan untuk menghapus data di
table database. Tambahkan perintah Where untuk memfilter data-data tertentu
yang akan dihapus. Jika tanpa perintah Where, maka seluruh data dalam tabel
akan terhapus.<br />
Syntax dasar :<br />
DELETE FROM table_name<br />
WHERE some_column=some_value<br />
Contoh: <br />
DELETE FROM bukutamu<br />
WHERE id=1</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;">
<b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">Update</span></b><span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";"></span>
</div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt;">
<span lang="EN-US" style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">Digunakan untuk mengubah/memperbarui
data di tabel database.<br />
<br />
Syntax dasar:<br />
UPDATE table_name<br />
SET column1=value,column2=value, . . .<br />
WHERE some_column=some_value<br />
Contoh :<br />
UPDATE bukutamu<br />
SET email=’arini@yahoo.com’, kota=’Jakarta’<br />
WHER<b>E</b></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;">
<br /></div>
<br />
<div class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt; margin-left: 36.0pt; mso-margin-top-alt: auto;">
<br /></div>
<ol start="2" type="1">
<li class="MsoNormal" style="line-height: normal; mso-list: l1 level1 lfo10; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt;"><b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">Data Manipulation Language
(DML)</span></b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"></span></li>
<ul type="circle">
<li class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt; mso-list: l1 level2 lfo10; mso-margin-top-alt: auto; tab-stops: list 72.0pt;"><b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">INSERT</span></b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
insert berfungsi untuk menambah niali pada suatu tabel.<br />
<i><br />
Contoh sintak</i><br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">insert
into namatabel values (‘value1’, ‘value2’,’ ...’)</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
<br />
keterangan : value adalah nilai yang ingin dimasukkan ke dalam kolom</span></li>
<li class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt; mso-list: l1 level2 lfo10; mso-margin-top-alt: auto; tab-stops: list 72.0pt;"><b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">UPDATE</span></b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
Berfungsi untuk merubah record atau nilai didalam suatu kolom<br />
<i><br />
Contoh sintak</i><br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">Update
namatabel SET namakolom = recordbaru where kondisi</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
<br />
keterangan recordbaru di ubah sesuai dengan nama nilai baru yang akan di
ubah</span></li>
<li class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt; mso-list: l1 level2 lfo10; mso-margin-top-alt: auto; tab-stops: list 72.0pt;"><b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">DELETE</span></b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
Menghapus record atau nilai didalam suatu kolom pada tabel tertentu<br />
<i><br />
Contoh sintak</i><br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">DELETE
namakolom from namatabel where kondisi</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br style="mso-special-character: line-break;" />
<br style="mso-special-character: line-break;" />
</span></li>
<li class="MsoNormal" style="line-height: normal; mso-list: l1 level2 lfo10; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 72.0pt;"><b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">SELECT</span></b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
select adalah perintah yang di gunakan untuk menampilkan nilai atau recor
yang di pilih<br />
<br />
<i><br />
Contoh sintak</i><br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">select
namakolom from namatabel </span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"></span></li>
</ul>
</ol>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt; margin-left: 36.0pt; mso-margin-top-alt: auto;">
<br /></div>
<ol start="3" type="1">
<li class="MsoNormal" style="line-height: normal; mso-list: l1 level1 lfo10; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt;"><b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">Data Control Language (DCL)</span></b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"></span></li>
<ul type="circle">
<li class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt; mso-list: l1 level2 lfo10; mso-margin-top-alt: auto; tab-stops: list 72.0pt;"><b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">GRANT </span></b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
grant berfungsi untuk memberikan izin akses kepada pengguna<br />
<br />
<i><br />
Contoh sintak</i><br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">Grant
privilages on namatabel to namapengguna</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
<br />
artinya memebrikan izin akses kepada namapengguna</span></li>
<li class="MsoNormal" style="line-height: normal; mso-list: l1 level2 lfo10; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 72.0pt;"><b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">REVOKE</span></b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
yaitu untuk mencabut izin akses kepada pengguna yang telah di beri izin
akses<br />
<br />
<i><br />
Contoh sintak</i><br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">REVOKE
privileges ON namatabel from namapengguna</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"></span></li>
</ul>
</ol>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt; margin-left: 36.0pt; mso-margin-top-alt: auto;">
<span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
<br />
<b> Macam – macam fungsi pada SQL</b></span></div>
<ol start="3" type="1"><ol start="3" type="1">
<li class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt; mso-list: l1 level2 lfo11; mso-margin-top-alt: auto;"><b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">Tanda *</span></b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
digunakan untuk memilih semua isi tabel<br />
<i><br />
Contoh sintak</i><br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">select *
from namatabel</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"></span></li>
<li class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt; mso-list: l1 level2 lfo11; mso-margin-top-alt: auto;"><b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">FungsiWHERE</span></b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
berfungsi untuk menentkan suatu pilihan atau kondisi tertentu<br />
<i><br />
Contoh sintak</i><br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">select *
from namatabel where namakolom = “kondisi”<br style="mso-special-character: line-break;" />
<br style="mso-special-character: line-break;" />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"></span></li>
<li class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt; mso-list: l1 level2 lfo11; mso-margin-top-alt: auto;"><b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">Fungsi DISTINC</span></b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"> <br />
digunakan untuk menghilangakan nilai ganda pada suatu kolom atau tabel<br />
<i><br />
Contoh sintak</i><br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">select
distinct namakolom from namatabel</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"></span></li>
<li class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt; mso-list: l1 level2 lfo11; mso-margin-top-alt: auto;"><b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">Operator AND</span></b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
digunakan untuk memilih nilai yang memiliki kondisi sama antara kondisi1
dan kondisi2<br />
contoh sintak <br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">select *
from namatabel where kondisi1=’..’ AND kondisi2 = ‘...’</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"></span></li>
<li class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt; mso-list: l1 level2 lfo11; mso-margin-top-alt: auto;"><b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">Operator OR</span></b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
digunakan untuk memilih suatu tabel atau kolom dan menampilkan nilai jika
salah satu kondisi dari kondisi yang di tentukan memenuhi<br />
<i><br />
Contoh sintak</i><br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">select *
from namatabel where kondisi1=’..’ OR kondisi2 = ‘...’</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"></span></li>
<li class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt; mso-list: l1 level2 lfo11; mso-margin-top-alt: auto;"><b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">Fungsi NOT</span></b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
di gunakan untuk memilih suatu nilai pada tabel atau kolom yang tidak
sama dengan kondisi yang telah di tentukan<br />
<i><br />
Contoh sintak</i><br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">selesct
* from namatabel where namakolom not = ‘kondisi’</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"></span></li>
<li class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt; mso-list: l1 level2 lfo11; mso-margin-top-alt: auto;"><b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">Fungsi ORDER BY</span></b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
digunakan untuk memilih suatu nilai dari tabel atau kolom dan mengurutkan
data tersebut<br />
<i><br />
Contoh sintak</i><br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">select
namakolom from nama tabel <br />
where namakolom = ‘kondisi’ <br />
order by namakolompengurut desc/asc<br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
keterangan : namakolompengurut adalah dasar pengurutan</span></li>
<li class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt; mso-list: l1 level2 lfo11; mso-margin-top-alt: auto;"><b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">Fungsi GROUP BY</span></b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
berfungsi untuk menelompokkan suatu data, namun pada pada fungsi ini juga
biasanya paling banyak melibatkan operator pembanding dan fungsi
perhitungan<br />
<i><br />
Contoh sintak</i><br />
s</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">elect
namakkolom from namatabel<br />
group by namakolomyangakandikelompokkan<br />
having count namakolom >4<br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
keterangan having count adalah fungsi yang digunakan untuk mendukung
fungsi group by.</span></li>
<li class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt; mso-list: l1 level2 lfo11; mso-margin-top-alt: auto;"><b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">Funsi BETWEEN</span></b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
fungsi between digunakan untuk memilih nilai di antara kondisi yang di
tentukan<br />
<i><br />
Contoh sintak</i><br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">select *
from namatabel where ‘kondisi’ between ‘kondisi’ – ‘kondisi’</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"></span></li>
<li class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt; mso-list: l1 level2 lfo11; mso-margin-top-alt: auto;"><b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">Fungsi PERHITUNGAN</span></b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
a. <b>Count</b> untuk mengitung jumlah baris atau kolom<br />
b. <b>Sum</b> di gunakan untuk menjumlahkan suatu nilai
yag memiliki type data numerik<br />
c. <b> Avg</b> berfungsi untuk membuat nilai rata – rata<br />
d. <b>Max</b> berfungsi untuk mencari nilai terbesar
dan<br />
e. <b>Min</b> untuk mencri nilai terkecil<br />
<i><br />
Contoh sintak</i><br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">select
avg namakolom from namatabe</span></li>
<li class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt; mso-list: l1 level2 lfo11; mso-margin-top-alt: auto;"><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;"><b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">Data Definisi Language
(DDL)</span></b></span><ol start="1" type="1">
<li class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt; mso-list: l1 level1 lfo10; mso-margin-top-alt: auto; tab-stops: list 36.0pt;"><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">
DDL merupakan bahasa atau perintah pada SQL yang digunakan untuk
mendefinisikan data seperti menulis, menghapus dan mengatur atau mengubah
data.<br />
Perintah – perintah yang ada pada komponen DDL yaitu CREATE, DROP, dan
ALTER.</span></li>
<ul type="circle">
<li class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt; mso-list: l1 level2 lfo10; mso-margin-top-alt: auto; tab-stops: list 72.0pt;"><b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">CREATE</span></b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
digunakan untuk membuat database, membuat tabel, membuat view dan membuat
index.<br />
<br />
<b><i>Membuat database</i></b><br />
<i>Contoh sintak</i><br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">Create
database namadatabase<br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
<b><i>Membuat tabel lengkap dengan kolomnya</i></b><br />
<br />
<i>Contoh sintak</i><br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">Create
table namatabel <br />
(namakolom1 typedata1,<br />
namakolom2 typedata2,<br />
namakolom3 typedata3)</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
<br />
Type data dapat berupa char(), int, numerik dan sebagainya sesuai denga
nama kolom.<br />
<br />
<b><i>Membuat view</i></b><br />
view merupakan bentuk alternatif penyajian data dari satu tabel atau
lebih, beberapa tujuan membuat view adalah meningkatkan keamanan data
serta penyederhanaan bagi para pengguna.<br />
<br />
<i>Contoh sintak</i><br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">Create
view namaview (kolom1, kolom2, . . . .) <br />
as select statement from namatabel<br />
[with check option]</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
<br />
Keterangan :<br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">Namaview</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"> : nama view yang dibuat<br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">Column</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"> : nama atribut untuk view<br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">Statement</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"> : atribut yang dipilih
dari tabel database<br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">Namatabel</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"> : nama tabel yang ada
pada basis data<br />
<br />
<b><i>Membuat index</i></b><br />
yaitu berfungsi untuk membuat index<br />
<br />
<i>Contoh sintak</i><br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">create
[unique] index namaindex <br />
on namatabel (namakolom)<br style="mso-special-character: line-break;" />
<br style="mso-special-character: line-break;" />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"></span></li>
<li class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt; mso-list: l1 level2 lfo10; mso-margin-top-alt: auto; tab-stops: list 72.0pt;"><b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">DROP</span></b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
Drop pada SQL adalah perintah yang di gunakan untuk menghapus data – data
yang telah di simpan pada database.<br />
<br />
<b><i>Drop tabel</i></b><br />
yaitu menghapus tabel<br />
<br />
<i>Contoh sintak</i><br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">Drop
table namatabel</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
<br />
<b><i>Drop view</i></b><br />
menghapus view yang telah di buat<br />
<br />
<i>Contoh sintak</i><br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">Drop
view namaview</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
<br />
<b><i>Drop index</i></b><br />
Menghapus index<br />
<br />
<i>Contoh sintak</i><br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">Drop
index namaindex</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
<br />
hal yang perlu di ingat adalah penghapusan atau penggunaan perintah view
tidak dapat di urungkan.<br style="mso-special-character: line-break;" />
<br style="mso-special-character: line-break;" />
</span></li>
<li class="MsoNormal" style="line-height: normal; mso-list: l1 level2 lfo10; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 72.0pt;"><b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">ALTER</span></b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
kegunaan dari perintah alter adalah untuk merubah atribut pada suatu
tabel<br />
<i><br />
Contoh sintak</i><br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">Alter
table namatabel<br />
Modify (namakolom typekolom</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">) untuk mengganti type kolom dan nama kolom.<br />
<br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">alter
table namatabel<br />
add (namakolom type kolom[[before, namakolom]])</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"> menambah kolom.<br />
<br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">alter
table namatabel<br />
drop (namakolom typekolom)</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"> untuk menghapus kolom pada sebuah tabel.</span></li>
</ul>
</ol>
<span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;"> </span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"></span></li>
<li class="MsoNormal" style="line-height: normal; mso-list: l1 level2 lfo11; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">Fungsi JOIN</span></b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"></span></li>
<ul type="square">
<li class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt; mso-list: l1 level3 lfo11; mso-margin-top-alt: auto; tab-stops: list 108.0pt;"><b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">INNER JOIN (SIMPLE JOIN)</span></b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
yaitu bentuk kondisi join dimana di antara 2 atau lebih tabel yang ingin
di join memiliki hubungan sehingga semua isi tabel yang di pilih bisa di
tampilkan<br />
<br />
<i><br />
Contoh sintak</i><br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">select
* from namatabel1 inner join namatabel2<br />
where namatabel1.kondisisama = namatabel1. kondisisama</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"></span></li>
<li class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt; mso-list: l1 level3 lfo11; mso-margin-top-alt: auto; tab-stops: list 108.0pt;"><b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">NON-EQUIJOIN</span></b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
adalah kondisi join yang tidak menagndung opertor sama dengan (=)<br />
<i><br />
Contoh sintak</i><br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">select
* from namatabel1 inner join namatabel2<br />
where namatabel1.kondisisama and namatabel1. kondisisama</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"></span></li>
<li class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt; mso-list: l1 level3 lfo11; mso-margin-top-alt: auto; tab-stops: list 108.0pt;"><b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">OUTER JOIN</span></b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
yaitu bentuk nilai join yang memenuhi daari kedua tabel, Outer
join terdiri dari 2 yaitu,</span></li>
<ol start="1" type="1">
<li class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt; mso-list: l1 level4 lfo11; mso-margin-top-alt: auto; tab-stops: list 144.0pt;"><b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">LEFT OUTER JOIN</span></b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
yaitu di tandai dengan operator (+), tabel asal atau yang memiliki
tanda (+) akan dilengkapi dengan tabel yang lainnya dan berada pada
sebelah kiri.<br />
<i><br />
Contoh sintak</i><br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">select
tabel1.kolom, tabel2.kolom<br />
from tabel1, tabel2<br />
where tabel1.kolom (+) = tabel2.kolom</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
<br />
atau<br />
<br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">select
tabel1.kolom, tabel2.kolom<br />
from tabel1 left outer join tabel2 <br />
on tabel1.kolom = tabel2.kolom</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"></span></li>
<li class="MsoNormal" style="line-height: normal; margin-bottom: 12.0pt; mso-list: l1 level4 lfo11; mso-margin-top-alt: auto; tab-stops: list 144.0pt;"><b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;">RIGHT OUTER JOIN</span></b><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
Sama dengan left outer join namun peletakan data atai nilai dari tabel
lain berada pada sebelah kanan tabel asal.<br />
<i><br />
Contoh sintak</i><br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">select
tabel1.kolom, tabel2.kolom<br />
from tabel1, tabel2<br />
where tabel1.kolom = tabel2.kolom(+)</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"><br />
<br />
atau<br />
<br />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Courier New"; mso-hansi-font-family: Batang;">select
tabel1.kolom, tabel2.kolom<br />
from tabel1 right outer join tabel2 <br />
on tabel1.kolom = tabel2.kolom<br style="mso-special-character: line-break;" />
</span><span lang="EN-US" style="font-family: Batang; font-size: 12.0pt; mso-bidi-font-family: "Times New Roman"; mso-hansi-font-family: Batang;"></span></li>
</ol>
</ul>
</ol>
</ol>
Anonymoushttp://www.blogger.com/profile/08492196053582288059noreply@blogger.com0tag:blogger.com,1999:blog-1054808945066458357.post-61790503469227643102015-03-18T03:47:00.001-07:002015-03-18T04:47:01.318-07:00TUGAS BASIS DATA TUTORIAL MEMBUAT DATABASE<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
NAMA : AHMAD HENDRAWAN</div>
<div class="separator" style="clear: both; text-align: center;">
KELAS: D3 TI 1B</div>
<div class="separator" style="clear: both; text-align: center;">
NPM: 1143003</div>
<div class="separator" style="clear: both; text-align: center;">
POLTEKPOS INDONESIA</div>
<div class="separator" style="clear: both; text-align: center;">
<img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNUg7WvSTd10YEkAOGKYMhnROMyqF2bPgaCKn3TB2Oq2Ievjnd1P8flcUDSzJXPfqki0ESfT8E-i_3TbG-7z2rmbPggxznEl_iqOeVa6AANtTSupfg8f9v1di7V3Xb9IDSp_cdbGAKiw4/s1600/0+buka+aplikasi.jpg" height="179" width="320" /> </div>
<div class="separator" style="clear: both; text-align: center;">
1.BUKA APLIKASI MICROSOFT SQLSERVER MANAGEMENT</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBIHqsw3wDnTrQpnnEtIeUz_k5Yqq23uv-qEki6zM8TDK9Ff0DDqw9vdy866s4S12SfHkmfMlx6Bxj1YEQyh3Zzfy8wXKfsQn723P6DGGyG6_4C7cl1OvWj0_npC6W0X754NDzGyztWyE/s1600/1+buat+database.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBIHqsw3wDnTrQpnnEtIeUz_k5Yqq23uv-qEki6zM8TDK9Ff0DDqw9vdy866s4S12SfHkmfMlx6Bxj1YEQyh3Zzfy8wXKfsQn723P6DGGyG6_4C7cl1OvWj0_npC6W0X754NDzGyztWyE/s1600/1+buat+database.jpg" height="179" width="320" /></a></div>
2. BUKA APLIKASI POWER DESIGNER DAN BUAT ENTITY DI TABEL POLETTE<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGDrkzLU1vka9RT6rHaDNwCbvWMcsqiggitsmgZGrAeqNXG7krGdmxJ8Mjc6Q4KKvGwDSk1hCp1ZVNHpCSXFMuYBDHP9Dw2s7jeNL7QSzNl1-QGAZBiBp0T4poScjpLOeyQ110nuRAYEc/s1600/2+buat+entity+di+palette.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGDrkzLU1vka9RT6rHaDNwCbvWMcsqiggitsmgZGrAeqNXG7krGdmxJ8Mjc6Q4KKvGwDSk1hCp1ZVNHpCSXFMuYBDHP9Dw2s7jeNL7QSzNl1-QGAZBiBp0T4poScjpLOeyQ110nuRAYEc/s1600/2+buat+entity+di+palette.jpg" height="179" width="320" /></a></div>
3.INPUT DATA DENGAN CARA MENGKLIK 2X DI KOTAK ENTITY<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFKnOm97IbVl7rovzQMM3mss7NShoNiy61GLk-yNiasTMPNjN7oTV8lcGTNDKr97lVslL_yFBDW62OEXGi2ihmZQEekZE3i-uENumf8I5LhZvmPa_37T1hnTMiZ2tWflgYaWGgLO-DiUU/s1600/3+input+data.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFKnOm97IbVl7rovzQMM3mss7NShoNiy61GLk-yNiasTMPNjN7oTV8lcGTNDKr97lVslL_yFBDW62OEXGi2ihmZQEekZE3i-uENumf8I5LhZvmPa_37T1hnTMiZ2tWflgYaWGgLO-DiUU/s1600/3+input+data.jpg" /></a></div>
4. LAKUKAN BERULANG-ULANG SEPERLUNYA<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjemt0_S-f_nb5npRwaskfEqnDH1WjF6gzVRrNi6Nw66R5njeI6sSoTVXPFV8wDovr0KfKpdgVmzM60vA365Cb9F4rPoQu4MOVG7gqu2Bhp_fUIddCExq-k8MwSS7_ShGU0nSKMo-zVBNk/s1600/4+tampilan+hasil.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjemt0_S-f_nb5npRwaskfEqnDH1WjF6gzVRrNi6Nw66R5njeI6sSoTVXPFV8wDovr0KfKpdgVmzM60vA365Cb9F4rPoQu4MOVG7gqu2Bhp_fUIddCExq-k8MwSS7_ShGU0nSKMo-zVBNk/s1600/4+tampilan+hasil.jpg" height="179" width="320" /></a></div>
5. SAVE KE MICROSOFT SQL SERVER 2008 ( DI TOOL)<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzfymfRh8FFZl9xrZTtNQKOWeD8nQGp-DqF9AOEWmiTK3o5TNJx04xarKS_xp847vjzMMKMZcQJvzg2gSP8VBb1D4vF8iD7WpG3Jdg9ui9l_YyC9dRcLm8XamlyNo7E5fcBeVC7wV1_PQ/s1600/5+save+ke+sql+server.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzfymfRh8FFZl9xrZTtNQKOWeD8nQGp-DqF9AOEWmiTK3o5TNJx04xarKS_xp847vjzMMKMZcQJvzg2gSP8VBb1D4vF8iD7WpG3Jdg9ui9l_YyC9dRcLm8XamlyNo7E5fcBeVC7wV1_PQ/s1600/5+save+ke+sql+server.jpg" height="179" width="320" /></a></div>
6.BUKA APLIKASI SQL LAGI MASUKAN FILE PDM<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4NEY7ZHh22RNd7rIlShcUMLwsLmcJmLlKu6IDNt82HAPlf-cVC0jyBbxZ59u21Zo60oIHcr_-pmX_7UZW777xjrnSN6E_zDzlUj_b62d7eceUE9aTELHZCJVHkP_EozsTlO4qABlS09Q/s1600/6+di+execute+dan+di+play.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4NEY7ZHh22RNd7rIlShcUMLwsLmcJmLlKu6IDNt82HAPlf-cVC0jyBbxZ59u21Zo60oIHcr_-pmX_7UZW777xjrnSN6E_zDzlUj_b62d7eceUE9aTELHZCJVHkP_EozsTlO4qABlS09Q/s1600/6+di+execute+dan+di+play.jpg" /></a></div>
7. LIAHT FILE DI DATABASE<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrkmV_trAj91VDIz9XHaqGwZawSfONAy1akZbIbGmhDZvYTb53IhPCOC0l-ESTsNYfhLHkuKV8WF91ulJ0o7-jfLKNs2g-GxriqrbcyiElgCHETbabNEHkDY61Y34RLmebuG__WNTkAcE/s1600/7+uka+database.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrkmV_trAj91VDIz9XHaqGwZawSfONAy1akZbIbGmhDZvYTb53IhPCOC0l-ESTsNYfhLHkuKV8WF91ulJ0o7-jfLKNs2g-GxriqrbcyiElgCHETbabNEHkDY61Y34RLmebuG__WNTkAcE/s1600/7+uka+database.jpg" height="179" width="320" /></a></div>
8.MASUKAN DATA DENGAN CARA KLIK KANAN DI FILE YANG AKAN DI INPUT PILIH SCRIP DAN INSERT TO<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiL0WZ_cHY5PCEM8cF2LIQ0W3g0Uaj6OxgNHuUWDI26Vxj0O0v5Tt2wi14xPJYbsELpxH7XlmqFpV3yzXhODQXIkhNtwYzaFpCmb7fg-IYFl6S71LJd0Y5_5M2uq54JetXIoRbAlX7VKs8/s1600/8+klik+kanan+di+bagian+isi+database.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiL0WZ_cHY5PCEM8cF2LIQ0W3g0Uaj6OxgNHuUWDI26Vxj0O0v5Tt2wi14xPJYbsELpxH7XlmqFpV3yzXhODQXIkhNtwYzaFpCmb7fg-IYFl6S71LJd0Y5_5M2uq54JetXIoRbAlX7VKs8/s1600/8+klik+kanan+di+bagian+isi+database.jpg" height="179" width="320" /></a></div>
9.EDIT<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-OQ11wv1JHj8sNRl6kG8M7I9mV4aEW8t1ZemNaH96nk_wAYzFd1js7sclkPKxupfEvv817xvte-jpjwFUUShU_1Ij6dOjx7jSJj8nBK-VyYF9xes4P1L_MsmTNhjmUq4Gh7oMHI1hekE/s1600/9+masukan+scrip.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-OQ11wv1JHj8sNRl6kG8M7I9mV4aEW8t1ZemNaH96nk_wAYzFd1js7sclkPKxupfEvv817xvte-jpjwFUUShU_1Ij6dOjx7jSJj8nBK-VyYF9xes4P1L_MsmTNhjmUq4Gh7oMHI1hekE/s1600/9+masukan+scrip.jpg" height="179" width="320" /></a></div>
10. PERIKSA DENGAN CARA KLIK KANAN KLIK SELECT TOP 1000 ROWS<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLabJ94IgkQw2HZQWmlGJGzehJpvBPVbYmNwbZ4T5Wkb_Ke6G9YRePy3AjmHJ4slf_sxxZU36GqDzPaojRQVESw67E8I1eMlUJ_mcVdNe8Fi0dTM1XKzo7v9TjBCWqALSSKSFGiMpoKdQ/s1600/10+cek+dengan+cara+klik+kanan+pilih+select+top+1000+rows.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLabJ94IgkQw2HZQWmlGJGzehJpvBPVbYmNwbZ4T5Wkb_Ke6G9YRePy3AjmHJ4slf_sxxZU36GqDzPaojRQVESw67E8I1eMlUJ_mcVdNe8Fi0dTM1XKzo7v9TjBCWqALSSKSFGiMpoKdQ/s1600/10+cek+dengan+cara+klik+kanan+pilih+select+top+1000+rows.jpg" /></a></div>
11. LAKUKAN BERULANG-ULANG<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEge3WovO4wuAhg1c9sc1oyU0KjtduFm13R6AyxwXIPSM3U4YVTqKQxemEYsvP0l7lJ-_Uf2ijnQxwmS1DLxtJhrByTFxIVhZeGRIEpDvpzAsvMrvmcuYC5o6Ea2-geNqYOBGtHFYZboAvY/s1600/11+lakukan+cara+yang+sama+ke+file+yang+lainnya.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEge3WovO4wuAhg1c9sc1oyU0KjtduFm13R6AyxwXIPSM3U4YVTqKQxemEYsvP0l7lJ-_Uf2ijnQxwmS1DLxtJhrByTFxIVhZeGRIEpDvpzAsvMrvmcuYC5o6Ea2-geNqYOBGtHFYZboAvY/s1600/11+lakukan+cara+yang+sama+ke+file+yang+lainnya.jpg" /></a></div>
<br />Anonymoushttp://www.blogger.com/profile/08492196053582288059noreply@blogger.com0