MACAM TIPE DATA

<!--[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>IN</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:DontVertAlignCellWithSp/> <w:DontBreakConstrainedForcedTables/> <w:DontVertAlignInTxbx/> <w:Word11KerningPairs/> <w:CachedColBalance/> </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]--><br /> <!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true" DefSemiHidden="true" DefQFormat="false" DefPriority="99" LatentStyleCount="267"> <w:LsdException Locked="false" Priority="0" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" Priority="39" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" Name="toc 9"/> <w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/> <w:LsdException Locked="false" Priority="10" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Title"/> <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/> <w:LsdException Locked="false" Priority="11" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" Priority="22" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" Priority="59" SemiHidden="false" UnhideWhenUsed="false" Name="Table Grid"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/> <w:LsdException Locked="false" Priority="34" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/> </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-qformat:yes; 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:10.0pt; mso-para-margin-left:0cm; line-height:115%; 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-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; 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;"> <b><span style="font-family: "Times New Roman","serif"; font-size: 13.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">BERBAGAI MACAM TIPE DATA </span></b></div> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <br /></div> <div align="center" class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm; mso-line-height-alt: 10.1pt; text-align: center;"> <b><i><u><span style="color: black; font-family: "Times New Roman","serif"; font-size: 18.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">SQLServer</span></u></i></b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> <div align="center" class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm; mso-line-height-alt: 10.1pt; text-align: center;"> <br /></div> <div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm; mso-line-height-alt: 10.1pt;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">SQL mempunyai kerja mengolah database tentu membutuhkan suatu nilai untuk menampun data.Jadi pengertian secara singkat dari tipe data adalah suatu ilai yang digunakan untuk menampung data. karena jenis data itu banyak maka<br /> inilah tipe data-tipe data itu. </span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> <ol start="1" type="1"> <li class="MsoNormal" style="line-height: 13.7pt; mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt;"><b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Char </span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">atau <b>Varchar</b> adalah tipe data untuk menampung data yang bertipe karakter atau alfabetic(a-z) contoh:-nama orang, nsms bsrsng dll.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></li> <li class="MsoNormal" style="line-height: 13.7pt; mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt;"><b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Integer</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"> atau sering di singkat <b>INT</b> adalah tipe data yang digunakan untuk menampung data yang bertipe angka atau numeric(0-9) contoh:-NIS, No ktp, No SIM dll.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></li> <li class="MsoNormal" style="line-height: 13.7pt; mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt;"><b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Date</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"> adalah tipe data yang digunakan untuk menampung data yang bertipe tanggal, bulan, dan tahun contoh:-tanggal lahir dll.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></li> <li class="MsoNormal" style="line-height: 13.7pt; mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt;"><b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Numeric</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"> adalah tipe data yang dapat menampung data berbentuk bilangan real contoh:-6.00 atau 7.25.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></li> <li class="MsoNormal" style="line-height: 13.7pt; mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt;"><b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Small INT</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"> adalah tipe data bilangan bulat yang <b>range</b>-nya lebih kecil dari integer.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></li> <li class="MsoNormal" style="line-height: 13.7pt; mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt;"><b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Decimal</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"> adalah tipe data yang dapat menampung data pecahan.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></li> <li class="MsoNormal" style="line-height: 13.7pt; mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt;"><b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Float </span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">adalah tipe data yang dpat menampung bilangan real (sama dengan numeric) contoh: 3,33.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></li> <li class="MsoNormal" style="line-height: 13.7pt; mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt;"><b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Double</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"> adlah tipe data yang bertipe float namun dengan ketelitian yang lebih tinggi contoh: 3,333333</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></li> <li class="MsoNormal" style="line-height: 13.7pt; mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt;"><b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Blob</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"> adalah tipe data yang dapat menampung data berbentuk gambar atau suara bertipe binner.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></li> <li class="MsoNormal" style="line-height: 13.7pt; mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt;"><b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Text</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"> adalah tipe data yang dapat menampung semua tipe data.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></li> <li class="MsoNormal" style="line-height: 13.7pt; mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt;"><b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Boolean</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"> adalah tipe data yang digunakan untuk menampung data yang bertipe logika dan hanya mengenal true dan false.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></li> <li class="MsoNormal" style="line-height: 13.7pt; mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt;"><b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Enum</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"> adalah tipe data yang digunakan untuk menampung data dengan 1 karakter saja.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></li> <li class="MsoNormal" style="line-height: 13.7pt; mso-list: l1 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt;"><b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Time</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"> adalah tipe data yang digunakan untk menampung data satuan waktu </span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></li> </ol> <div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm; mso-line-height-alt: 10.1pt;"> <br /></div> <div align="center" class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm; mso-line-height-alt: 10.1pt; text-align: center;"> <b><i><u><span style="color: black; font-family: "Times New Roman","serif"; font-size: 18.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">MYSQL</span></u></i></b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> <div align="center" class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm; mso-line-height-alt: 10.1pt; text-align: center;"> <br /></div> <div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm; mso-line-height-alt: 10.1pt;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">MySQL adalah sebuah implementasi dari sistem manajemen basisdata relasional (</span><a href="http://id.wikipedia.org/wiki/RDBMS"><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN; text-decoration: none; text-underline: none;">RDBMS</span></a><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">) yang didistribusikan secara gratis dibawah </span><a href="http://id.wikipedia.org/wiki/GPL"><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN; text-decoration: none; text-underline: none;">lisensi GPL</span></a><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"> (General Public License). Setiap pengguna dapat secara bebas menggunakan MySQL, namun dengan batasan perangkat lunak tersebut tidak boleh dijadikan produk turunan yang bersifat komersial. MySQL sebenarnya merupakan turunan salah satu konsep utama dalam basisdata yang telah ada sebelumnya; </span><a href="http://id.wikipedia.org/wiki/SQL"><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN; text-decoration: none; text-underline: none;">SQL</span></a><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"> (Structured Query Language). SQL adalah sebuah konsep pengoperasian basisdata, terutama untuk pemilihan atau seleksi dan pemasukan data, yang memungkinkan pengoperasian data dikerjakan dengan mudah secara otomatis. </span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> <div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm; mso-line-height-alt: 10.1pt;"> <br /></div> <div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm; mso-line-height-alt: 10.1pt;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">1. Tipe data untuk bilangan</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> <table border="1" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="mso-cellspacing: 0cm; mso-padding-alt: 1.5pt 1.5pt 1.5pt 1.5pt; mso-yfti-tbllook: 1184; width: 592px;"> <tbody> <tr style="mso-yfti-firstrow: yes; mso-yfti-irow: 0;"> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 22.5pt;" valign="top" width="30"> <div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: center;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">No</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 93.75pt;" valign="top" width="125"> <div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: center;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Tipe Data</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 317.25pt;" valign="top" width="423"> <div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: center;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Keterangan</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> </tr> <tr style="mso-yfti-irow: 1;"> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 22.5pt;" valign="top" width="30"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">1.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 93.75pt;" valign="top" width="125"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">TINYINT</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 317.25pt;" valign="top" width="423"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Ukuran 1 byte. Bilangan bulat terkecil,<br /> dengan jangkauan untuk bilangan bertanda -128 sampai dengan 127 dan untuk<br /> yang tidak bertanda 0 sampai dengan 255. Bilangan tak bertanda ditandai<br /> dengan kata UNSIGNED</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> </tr> <tr style="mso-yfti-irow: 2;"> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 22.5pt;" valign="top" width="30"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">2.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 93.75pt;" valign="top" width="125"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">SMALLINT</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 317.25pt;" valign="top" width="423"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Ukuran 2 byte. Bilangan bulat dengan<br /> jangkauan untuk bilangan bertanda -32768 sampai dengan 32767 dan untuk yang<br /> tidak bertanda 0 sampai dengan 65535</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> </tr> <tr style="mso-yfti-irow: 3;"> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 22.5pt;" valign="top" width="30"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">3.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 93.75pt;" valign="top" width="125"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">MEDIUMINT</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 317.25pt;" valign="top" width="423"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Ukuran 3 byte. Bilangan bulat dengan<br /> jangkauan untuk bilangan bertanda -8388608 sampai dengan 8388607 dan untuk<br /> yang tidak bertanda 0 sampai dengan 16777215</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> </tr> <tr style="mso-yfti-irow: 4;"> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 22.5pt;" valign="top" width="30"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">4.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 93.75pt;" valign="top" width="125"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">INT</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 317.25pt;" valign="top" width="423"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Ukuran 4 byte. Bilangan bulat dengan<br /> jangkauan untuk bilangan bertanda -2147483648 sampai dengan 2147483647 dan<br /> untuk yang tidak bertanda 0 sampai dengan 4294967295</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> </tr> <tr style="mso-yfti-irow: 5;"> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 22.5pt;" valign="top" width="30"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">5.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 93.75pt;" valign="top" width="125"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">INTEGER</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 317.25pt;" valign="top" width="423"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Sama dengan INT.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> </tr> <tr style="mso-yfti-irow: 6;"> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 22.5pt;" valign="top" width="30"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">6.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 93.75pt;" valign="top" width="125"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">BIGINT</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 317.25pt;" valign="top" width="423"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Ukuran 8 byte. Bilangan bulat dengan<br /> jangkauan untuk bilangan bertanda -9223372036854775808 sampai dengan<br /> 9223372036854775807 dan untuk yang tidak bertanda 0 sampai dengan<br /> 184467440737079551615</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> </tr> <tr style="mso-yfti-irow: 7;"> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 22.5pt;" valign="top" width="30"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">7.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 93.75pt;" valign="top" width="125"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">FLOAT</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 317.25pt;" valign="top" width="423"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Ukuran 4 byte. Biilangan pecahan.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> </tr> <tr style="mso-yfti-irow: 8;"> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 22.5pt;" valign="top" width="30"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">8.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 93.75pt;" valign="top" width="125"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">DOUBLE</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 317.25pt;" valign="top" width="423"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Ukuran 8 byte. Bilangan pecahan.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> </tr> <tr style="mso-yfti-irow: 9;"> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 22.5pt;" valign="top" width="30"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">9.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 93.75pt;" valign="top" width="125"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">DOUBLE PRECISION</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 317.25pt;" valign="top" width="423"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Ukuran 8 byte. Bilangan pecahan berpresisi<br /> ganda.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> </tr> <tr style="mso-yfti-irow: 10;"> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 22.5pt;" valign="top" width="30"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">10.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 93.75pt;" valign="top" width="125"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">REAL</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 317.25pt;" valign="top" width="423"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Ukuran 8 byte. Sinonim dari DOUBLE.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> </tr> <tr style="mso-yfti-irow: 11;"> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 22.5pt;" valign="top" width="30"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">11.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 93.75pt;" valign="top" width="125"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">DECIMAL(M,D)</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 317.25pt;" valign="top" width="423"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Ukuran M byte. Bilangan pecahan. Misalnya<br /> DECIMAL(5,2) dapat digunakan untuk menyimpan bilangan -99,99 sampai dengan<br /> 99,99</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> </tr> <tr style="mso-yfti-irow: 12; mso-yfti-lastrow: yes;"> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 22.5pt;" valign="top" width="30"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">12.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 93.75pt;" valign="top" width="125"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">NUMERIC(M,D)</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 317.25pt;" valign="top" width="423"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Ukuran M byte. Sama dengan Decimal.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> </tr> </tbody></table> <div class="MsoNormal" style="line-height: 18.0pt; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">2. Tipe data untuk tanggal dan jam</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> <table border="1" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="mso-cellspacing: 0cm; mso-padding-alt: 1.5pt 1.5pt 1.5pt 1.5pt; mso-yfti-tbllook: 1184; width: 592px;"> <tbody> <tr style="mso-yfti-firstrow: yes; mso-yfti-irow: 0;"> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 22.5pt;" valign="top" width="30"> <div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: center;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">No</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 93.75pt;" valign="top" width="125"> <div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: center;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Tipe<br /> Data</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 317.25pt;" valign="top" width="423"> <div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: center;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Keterangan</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> </tr> <tr style="mso-yfti-irow: 1;"> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 22.5pt;" valign="top" width="30"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">1.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 93.75pt;" valign="top" width="125"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">DATETIME</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 317.25pt;" valign="top" width="423"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Ukuran 8 byte. Kombinasi tanggal dan jam<br /> dengan jangkauan dari ‘1000-01-01 00:00:00’ sampai dengan ‘9999-12-31<br /> 23:59:59’</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> </tr> <tr style="mso-yfti-irow: 2;"> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 22.5pt;" valign="top" width="30"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">2.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 93.75pt;" valign="top" width="125"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">DATE</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 317.25pt;" valign="top" width="423"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Ukuran 8 byte. Kombinasi tanggal dan jam<br /> dengan jangkauan dari ‘1000-01-01’ sampai dengan ‘9999-12-31 ’</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> </tr> <tr style="mso-yfti-irow: 3;"> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 22.5pt;" valign="top" width="30"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">3.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 93.75pt;" valign="top" width="125"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">TIMESTAMP</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 317.25pt;" valign="top" width="423"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Ukuran 4 byte. Kombinasi tanggal dan jam<br /> dengan jangkauan dari ‘1970-01-01’ sampai dengan ‘2037 ’</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> </tr> <tr style="mso-yfti-irow: 4;"> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 22.5pt;" valign="top" width="30"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">4.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 93.75pt;" valign="top" width="125"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">TIME</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 317.25pt;" valign="top" width="423"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Ukuran 3 byte.waktu dengan jangkauan dari<br /> -838:59:59 sampai dengan 838:59:59</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> </tr> <tr style="mso-yfti-irow: 5; mso-yfti-lastrow: yes;"> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 22.5pt;" valign="top" width="30"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">5.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 93.75pt;" valign="top" width="125"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">YEAR</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 317.25pt;" valign="top" width="423"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Ukuran 1 byte. Data tahun antara 1901 sampai<br /> dengan 2155</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> </tr> </tbody></table> <div class="MsoNormal" style="line-height: 18.0pt; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">3. Tipe data untuk karakter dan lain-lain</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> <table border="1" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="mso-cellspacing: 0cm; mso-padding-alt: 1.5pt 1.5pt 1.5pt 1.5pt; mso-yfti-tbllook: 1184; width: 592px;"> <tbody> <tr style="mso-yfti-firstrow: yes; mso-yfti-irow: 0;"> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 22.5pt;" valign="top" width="30"> <div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: center;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">No</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 93.75pt;" valign="top" width="125"> <div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: center;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Tipe<br /> Data</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 317.25pt;" valign="top" width="423"> <div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: center;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Keterangan</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> </tr> <tr style="mso-yfti-irow: 1;"> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 22.5pt;" valign="top" width="30"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">1.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 93.75pt;" valign="top" width="125"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">CHAR(M)</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 317.25pt;" valign="top" width="423"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Ukuran M byte, 1<=M<=255. Data string<br /> dengan panjang yang tetap. CHAR(1) cukup ditulis dengan CHAR.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> </tr> <tr style="mso-yfti-irow: 2;"> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 22.5pt;" valign="top" width="30"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">2.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 93.75pt;" valign="top" width="125"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">VARCHAR(M)</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 317.25pt;" valign="top" width="423"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Ukuran L+1 byte dengan L<=M dan<br /> 1<=M<=255. Data string dengan panjang bervariasi tergantung datanya.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> </tr> <tr style="mso-yfti-irow: 3;"> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 22.5pt;" valign="top" width="30"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">3.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 93.75pt;" valign="top" width="125"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">TINYBLOB,</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">TINYTEXT</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 317.25pt;" valign="top" width="423"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">L+1 byte, dengan L<28 . Tipe<br /> TEXT atau BLOB dengan panjang maksimum 255 karakter.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> </tr> <tr style="mso-yfti-irow: 4;"> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 22.5pt;" valign="top" width="30"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">4.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 93.75pt;" valign="top" width="125"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">BLOB, TEXT</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 317.25pt;" valign="top" width="423"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">L+2 byte, dengan L<216 . Tipe<br /> TEXT atau BLOB dengan panjang maksimum 65535 karakter.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> </tr> <tr style="mso-yfti-irow: 5;"> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 22.5pt;" valign="top" width="30"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">5.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 93.75pt;" valign="top" width="125"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">MEDIUMBLOB, MEDIUMTEXT</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 317.25pt;" valign="top" width="423"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">L+3 byte, dengan L<224. Tipe<br /> TEXT atau BLOB dengan panjang maksimum 1677215 karakter.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> </tr> <tr style="mso-yfti-irow: 6;"> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 22.5pt;" valign="top" width="30"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">6.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 93.75pt;" valign="top" width="125"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">LONGBLOB, LONGTEXT</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 317.25pt;" valign="top" width="423"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">L+4 byte, dengan L<232. Tipe<br /> TEXT atau BLOB dengan panjang maksimum 4294967295 karakter.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> </tr> <tr style="mso-yfti-irow: 7;"> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 22.5pt;" valign="top" width="30"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">7.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 93.75pt;" valign="top" width="125"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">ENUM(’nilai1’,’nilai2’,..)</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 317.25pt;" valign="top" width="423"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Ukuran 1 atau 2 byte tergantungnilai<br /> enumerasinya maks 65535 nilai</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> </tr> <tr style="mso-yfti-irow: 8; mso-yfti-lastrow: yes;"> <td style="background: #F2F8FA; padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 22.5pt;" valign="top" width="30"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">8.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="background: #F2F8FA; padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 93.75pt;" valign="top" width="125"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">SET(’nilai1’,’nilai2’,..)</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> <td style="background: #F2F8FA; padding: 1.5pt 1.5pt 1.5pt 1.5pt; width: 317.25pt;" valign="top" width="423"> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Ukuran 1,2,3,4 atau 8 byte tergantung jumlah<br /> anggota himpunan maks 64 anggota.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> </td> </tr> </tbody></table> <div class="MsoNormal" style="line-height: 18.0pt;"> <br /></div> <div align="center" class="MsoNormal" style="line-height: 18.0pt; text-align: center;"> <b><i><u><span style="color: black; font-family: "Times New Roman","serif"; font-size: 18.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">ORACLE</span></u></i></b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> <div class="MsoNormal" style="line-height: 18.0pt;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Basis data Oracle adalah </span><a href="http://id.wikipedia.org/wiki/Basis_data"><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN; text-decoration: none; text-underline: none;">basis data</span></a><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"> relasional yang terdiri dari kumpulan data dalam suatu sistem manajemen basis data </span><a href="http://id.wikipedia.org/wiki/RDBMS"><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN; text-decoration: none; text-underline: none;">RDBMS</span></a><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">. Perusahaan </span><a href="http://id.wikipedia.org/wiki/Perangkat_lunak"><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN; text-decoration: none; text-underline: none;">perangkat lunak</span></a><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"> Oracle memasarkan jenis basis data ini untuk bermacam-macam aplikasi yang bisa berjalan pada banyak jenis dan merk </span><a href="http://id.wikipedia.org/wiki/Perangkat_keras"><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN; text-decoration: none; text-underline: none;">perangkat keras</span></a><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"> komputer (<i>platform</i>).</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> <div class="MsoNormal" style="line-height: 14.4pt; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Basis data Oracle ini pertama kali dikembangkan oleh </span><a href="http://id.wikipedia.org/wiki/Larry_Ellison"><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN; text-decoration: none; text-underline: none;">Larry Ellison</span></a><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">, </span><a href="http://id.wikipedia.org/w/index.php?title=Bob_Miner&action=edit&redlink=1"><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN; text-decoration: none; text-underline: none;">Bob Miner</span></a><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"> dan </span><a href="http://id.wikipedia.org/w/index.php?title=Ed_Oates&action=edit&redlink=1"><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN; text-decoration: none; text-underline: none;">Ed Oates</span></a><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"> lewat perusahaan konsultasinya bernama <i>Software Development Laboratories (SDL</i>) pada tahun 1977. Pada tahun 1983, perusahaan ini berubah nama menjadi Oracle Corporation sampai sekarang.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> <div class="MsoNormal" style="line-height: 18.0pt;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Varchar2(size) : string yang memiliki panjang karakter vaiable dengan panjang maxial sebesar size. Tipe data ini memperbolehkan penyimpanan semua karakter yang dapat dimasukkan melalui keyboad. Maksimum size yang dapat disimpan sebesar 4000 bytes (karakter). Tipe data ini juga memungkinkan untuk mneyimpan data numerik. Biasanya space akan langsung dieliminasi jika menggunakan tipe ini.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> <ol start="1" type="1"> <li class="MsoNormal" style="line-height: 14.4pt; mso-list: l0 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt;"><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Char(size): string dengan panjan gkarakter tetap sebesar ukuran size. Tipe data ini mempunyai kemampuan yang hampir sama yakni menyimpan karakter, hanya saja maksimum size yang disimpan hanya sebesar 2000 bytes.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></li> <li class="MsoNormal" style="line-height: 14.4pt; mso-list: l0 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt;"><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Number(p,s) : tipe data number memiliki presisi p dan s digit dibelakan koma jika kita abaikan p dan s berarti dianggap sebagai tipe number floating point. Tipe data ini menyimpan bilangan interger sampai maksimum dari digit integer tersebut. misal untuk spesifikasi (5,2) berarti 3 digit sebelum koma dan 2 digit dibelakang koma.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></li> <li class="MsoNormal" style="line-height: 14.4pt; mso-list: l0 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt;"><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Long : data karakter dengan ukuran panjang bervariasi, hingga mencapai 2 GB.(tipe data seperti ini tidak dapat digunakan sebagai primary key).</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></li> <li class="MsoNormal" style="line-height: 14.4pt; mso-list: l0 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt;"><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Raw(size) : tipe data berupa binary data dengan ukuran maksimal 255 bytes</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></li> <li class="MsoNormal" style="line-height: 14.4pt; mso-list: l0 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt;"><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Long Raw : Tipe data berupa binary data dengan ukuran maksimal 2 GigaBytes tidak dikonversi oleh oracle (data mentah apa adanya, spasi dihitung 1 karakter).</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></li> <li class="MsoNormal" style="line-height: 14.4pt; mso-list: l0 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt;"><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Date : Tipe data ini menyimpan waktu dan tanggal dari sebuah informasi, dengan komponen waktu yang dibulatkan ke detik terdekat. Untuk menampilkannya dalam teks harus menggunakan fungsi to_char.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></li> <li class="MsoNormal" style="line-height: 14.4pt; mso-list: l0 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt;"><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Timestamp : tipe ini mirip dengan date. Di dalam tipe ini terdapat komponen waktu yang dapat langsung ditampilkan tanpa harus mengubahnya terlebih dahulu dengan fungsi to_char.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></li> <li class="MsoNormal" style="line-height: 14.4pt; mso-list: l0 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt;"><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Clob : Tipe data ini memperbolehkan penyimpanan objek dengan ukuran yang sangat besar sekitar 4 GB. Clob mirip sekali dengan varchar2 hanya saja tipe data ini mempunyai kapasitas maksimum yang lebih besar.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></li> <li class="MsoNormal" style="line-height: 14.4pt; mso-list: l0 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list 36.0pt;"><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Blob : tipe ini memperbolehkan penyimpanan objek bbinary yang besar dan tidak terstruktur. Contoh dari tipe data blob adalah suara dan video.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></li> </ol> <div class="MsoNormal" style="line-height: 18.0pt;"> <br /></div> <div align="center" class="MsoNormal" style="line-height: 18.0pt; text-align: center;"> <b><i><u><span style="color: black; font-family: "Times New Roman","serif"; font-size: 18.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">ACCESS</span></u></i></b><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> <div class="MsoNormal" style="line-height: 18.0pt;"> <b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Microsoft Access</span></b><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"> (atau <b>Microsoft Office Access</b>) adalah sebuah </span><a href="http://id.wikipedia.org/wiki/Program_komputer"><span style="color: blue; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">program</span></a><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"> aplikasi </span><a href="http://id.wikipedia.org/wiki/Basis_data"><span style="color: blue; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">basis data</span></a><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"> </span><a href="http://id.wikipedia.org/wiki/Komputer"><span style="color: blue; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">komputer</span></a><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"> </span><a href="http://id.wikipedia.org/wiki/RDBMS"><span style="color: blue; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">relasional</span></a><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"> yang ditujukan untuk kalangan rumahan dan perusahaan kecil hingga menengah. Aplikasi ini merupakan anggota dari beberapa aplikasi </span><a href="http://id.wikipedia.org/wiki/Microsoft_Office"><span style="color: blue; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Microsoft Office</span></a><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">, selain tentunya </span><a href="http://id.wikipedia.org/wiki/Microsoft_Word"><span style="color: blue; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Microsoft Word</span></a><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">, </span><a href="http://id.wikipedia.org/wiki/Microsoft_Excel"><span style="color: blue; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Microsoft Excel</span></a><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">, dan </span><a href="http://id.wikipedia.org/wiki/Microsoft_PowerPoint"><span style="color: blue; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Microsoft PowerPoint</span></a><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">. Aplikasi ini menggunakan mesin basis data </span><a href="http://id.wikipedia.org/wiki/Microsoft_Jet_Database_Engine"><span style="color: blue; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Microsoft Jet Database Engine</span></a><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">, dan juga menggunakan tampilan </span><a href="http://id.wikipedia.org/wiki/Graphical_user_interface"><span style="color: blue; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">grafis</span></a><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"> yang intuitif sehingga memudahkan pengguna.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Microsoft Access dapat menggunakan data yang disimpan di dalam format Microsoft Access, Microsoft Jet Database Engine, </span><a href="http://id.wikipedia.org/wiki/Microsoft_SQL_Server"><span style="color: blue; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Microsoft SQL Server</span></a><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">, </span><a href="http://id.wikipedia.org/wiki/Oracle_Database"><span style="color: blue; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">Oracle Database</span></a><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">, atau semua kontainer basis data yang mendukung standar </span><a href="http://id.wikipedia.org/wiki/Open_Database_Connectivity"><span style="color: blue; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">ODBC</span></a><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">. Para pengguna/</span><a href="http://id.wikipedia.org/wiki/Programmer"><i><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN; text-decoration: none; text-underline: none;">programmer</span></i></a><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"> yang mahir dapat menggunakannya untuk mengembangkan perangkat lunak aplikasi yang kompleks, sementara para </span><a href="http://id.wikipedia.org/wiki/Programmer"><span style="color: blue; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">programmer</span></a><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"> yang kurang mahir dapat menggunakannya untuk mengembangkan perangkat lunak aplikasi yang sederhana. Access juga mendukung teknik-teknik </span><a href="http://id.wikipedia.org/wiki/Pemrograman_berorientasi_objek"><span style="color: blue; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">pemrograman berorientasi objek</span></a><span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">, tetapi tidak dapat digolongkan ke dalam perangkat bantu pemrograman berorientasi objek.</span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> <div class="MsoNormal" style="line-height: 18.0pt; margin-left: 36.0pt;"> <span style="color: black; font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;">1. Tipe Data Field<br /> Field-field dalam sebuah tabel haruslah ditentukan tipe datanya agar Access mengetahui bagaimana agar data tersebut dapat diolah dan memperlakukan data dalam field itu. Oleh karena itu sangat penting bagi kita untuk memahami berbagai tipe data field yang ada. Bahkan pengetahuan mengenai hal ini akan bermanfaat ketika Anda merancang berbagai macam tabel dalam sebuah database.<br /> <br /> 2. Text<br /> Ini adalah tipe data yang paling umum digunakan. Tipe data ini bisa digunakan untuk field alfanumeric, seperti nama, alamat, kode pos, nomor telepon dan sebagainya. Microsoft Access memberi keleluasaan bagi Anda untuk memasukkan data sampai 255 karakter ke field dengan tipe data ini.<br /> <br /> <br /> 3. Memo<br /> Tipe data ini mirip dengan teks, tetapi bisa menampung sampai dengan 64.000 karakter. Tipe data text lebih sering dugunakan karena memo tidak bisa diurutkan atau diindeks.<br /> <br /> 4. Number<br /> Tipe data ini digunakan untuk menyimpan data numeric yang akan digunakan untuk perhitungan matematis. Anda tidak menggunakan tipe data ini untuk nomor telepon, misalnya, karena nomor telepon tidak perlu diproses secara matematis.<br /> <br /> 5. Date/Time<br /> Tipe data ini digunakan untuk nilai tanggal dan waktu. Misalnya, Anda bisa menggunakan tipe data ini untuk tanggal lahir atau tanggal pembelian.<br /> <br /> 6. Currency<br /> Tipe data ini terutama digunakan untuk nilai mata uang. Tetapi, Anda juga bisa menyertakan data numeric dalam perhitungan yang memerlukan satu sampai empat angka desimal. Tipe data ini, misalnya, bisa digunakan untuk nilai pembelian atau ongkos pengantaran. </span><span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: IN;"></span></div> <div class="MsoNormal"> <br /></div>

MACAM TIPE DATA

Normal 0 false false false IN X-NONE X-NONE

Baca selengkapnya »