{"id":1533,"date":"2020-02-09T22:53:03","date_gmt":"2020-02-09T13:53:03","guid":{"rendered":"https:\/\/oboki.net\/?p=1533"},"modified":"2020-05-06T22:56:16","modified_gmt":"2020-05-06T13:56:16","slug":"impala-rpad-ascii-code%eb%a5%bc-%ec%9d%b4%ec%9a%a9%ed%95%9c-%eb%b2%94%ec%9c%84-%ea%b2%80%ec%83%89","status":"publish","type":"post","link":"https:\/\/oboki.net\/workspace\/sql\/impala-rpad-ascii-code%eb%a5%bc-%ec%9d%b4%ec%9a%a9%ed%95%9c-%eb%b2%94%ec%9c%84-%ea%b2%80%ec%83%89\/","title":{"rendered":"[impala] rpad\uc640 \uc544\uc2a4\ud0a4 \ucf54\ub4dc\ub97c \uc774\uc6a9\ud55c \uc778\ub371\uc2a4 \uceec\ub7fc \ubc94\uc704 \uac80\uc0c9"},"content":{"rendered":"

rpad \ubb38\ubc95\uc740 rpad(A,N,B)<\/code> \uc640 \uac19\uc774 \uc37c\uc744 \ub54c, \uc804\uccb4 \ubb38\uc790\uc5f4 \uae38\uc774\uac00 N \ub9cc\ud07c \ub418\ub3c4\ub85d B \ubb38\uc790\uc5f4\uc744 \ubd99\uc5ec\uc900\ub2e4. \ub54c\ubb38\uc5d0 fixed-width \uceec\ub7fc\uc758 \uac12\uc774\ub098 \uac80\uc0c9 \uc870\uac74\uc744 \ub9cc\ub4e4\uc5b4\ub0b4\ub294 \ub370\uc5d0 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/p>\n

\uc6b0\ub9ac \uc2dc\uc2a4\ud15c\uc5d0\uc11c\ub294 \ud2b9\uc815 \uc774\ubca4\ud2b8\ub97c \uc2dd\ubcc4\ud558\uae30 \uc704\ud574\uc11c \ub9e8 \uc55e \uc5f4 \uc5ec\uc12f \uc790\ub9ac\ub294 \ud574\ub2f9 \uc774\ubca4\ud2b8 \ubc1c\uc0dd \uc2dc\uac04\uc774\uba74\uc11c 33 \uc790\ub9ac\uc778 id\ub97c \ud0a4\ub85c \uc0ac\uc6a9\ud558\uace0 \uc788\ub294\ub370 \uc774 \ub54c\uc5d0 rpad<\/code> \ub97c \ud65c\uc6a9\ud558\uba74 \uc720\uc6a9\ud558\ub2e4.<\/p>\n

\ud2b9\uc815 \uc2dc\uac04 \ub300(2020\/01\/24 09:00 ~ 09:10)\uc758 \uc774\ubca4\ud2b8\ub4e4\uc744 \uc870\ud68c\ud558\uace0\uc790 \ud558\ub294 \uacbd\uc6b0 \ub2e4\uc74c\uacfc \uac19\uc774 \uc870\ud68c\ud574\ubcfc \uc218 \uc788\uaca0\ub2e4.<\/p>\n

 where eid >= rpad('202001240900',33,chr(33))\n   and eid <  rpad('202001241000',33,chr(33))<\/code><\/pre>\n
eid \uc5d0\ub294 \ud2b9\uc218\ubb38\uc790\ub3c4 \ud3ec\ud568\ub420 \uc218 \uc788\uae30 \ub584\ubb38\uc5d0, printable character \uc911\uc5d0\uc11c \uac00\uc7a5 \ub0ae\uc740 \uac12\uc778 chr(33)<\/code>('!'<\/code>) \ub97c \ucc44\uc6cc\uc8fc\uba74 \ud574\ub2f9 \uad6c\uac04\uc758 \ubaa8\ub4e0 \uc774\ubca4\ud2b8\ub97c \uc870\ud68c\ud574\ubcfc \uc218 \uc788\ub2e4.<\/p>\n
between<\/code> \uad6c\ubb38\uc744 \uad73\uc774 \uc0ac\uc6a9\ud558\ub824\uace0 \ud55c\ub2e4\uba74 \uac00\uc7a5 \ub192\uc740 \uac12\uc778 chr(126)<\/code>('~'<\/code>) \uac12\uc744 \ucc44\uc6cc\uc8fc\uba74 \ub41c\ub2e4.<\/p>\n
 where eid between rpad('202001240900',33,chr(33))\n               and rpad('202001241000',33,chr(126))<\/code><\/pre>\n
eid<\/code> \uceec\ub7fc\uc5d0 substr \uc744 \uc774\uc6a9\ud558\ub294 \ubc29\uc2dd\uc73c\ub85c \uac80\uc0c9\ud560 \uc218\ub3c4 \uc788\uaca0\uc9c0\ub9cc \ud480\uc2a4\uce94\uc774 \uc77c\uc5b4\ub0a0 \uc218 \uc788\uae30 \ub54c\ubb38\uc5d0 \uac80\uc0c9 \uc870\uac74\uc5d0 \ubb38\uc790\uc5f4\uc744 \ud328\ub529\ud574\uc11c \uac80\uc0c9\ud558\ub294 \uac83\uc774 \uc778\ub371\uc2a4\ub97c \uc81c\ub300\ub85c \ud65c\uc6a9\ud560 \uc218 \uc788\uace0 \ub354 \ub098\uc740 \ubc29\ubc95\uc774\ub2e4.<\/p>\n
\uc544\uc2a4\ud0a4 \ucf54\ub4dc \ud45c<\/h2>\n
\ub2e4\uc74c\uacfc \uac19\uc774 \uc815\ub9ac\uac00 \uc798 \ub41c \ud14c\uc774\ube14\uc774 \uc788\uc5b4\uc11c \ud558\ub098 \uac00\uc838\uc640\ubd24\ub2e4.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Bin.<\/th>\nHex.<\/th>\nDec.<\/th>\nSymbol<\/th>\nExplanation<\/th>\n<\/tr>\n<\/thead>\n
0000000<\/td>\n0<\/td>\n0<\/td>\nNUL<\/td>\nThe null character prompts the device to do nothing Control Character<\/td>\n<\/tr>\n
0000001<\/td>\n1<\/td>\n1<\/td>\nSOH<\/td>\nInitiates a header (Start of Heading) Control Character<\/td>\n<\/tr>\n
0000010<\/td>\n2<\/td>\n2<\/td>\nSTX<\/td>\nEnds the header and marks the beginning of a message. (start of text) Control Character<\/td>\n<\/tr>\n
0000011<\/td>\n3<\/td>\n3<\/td>\nETX<\/td>\nIndicates the end of the message (end of text) Control Character<\/td>\n<\/tr>\n
0000100<\/td>\n4<\/td>\n4<\/td>\nEOT<\/td>\nMarks the end of a completes transmission (End of Transmission) Control Character<\/td>\n<\/tr>\n
0000101<\/td>\n5<\/td>\n5<\/td>\nENQ<\/td>\nA request that requires a response (Enquiry) Control Character<\/td>\n<\/tr>\n
0000110<\/td>\n6<\/td>\n6<\/td>\nACK<\/td>\nGives a positive answer to the request (Acknowledge) Control Character<\/td>\n<\/tr>\n
0000111<\/td>\n7<\/td>\n7<\/td>\nBEL<\/td>\nTriggers a beep (Bell) Control Character<\/td>\n<\/tr>\n
0001000<\/td>\n8<\/td>\n8<\/td>\nBS<\/td>\nLets the cursor move back one step (Backspace) Control Character<\/td>\n<\/tr>\n
0001001<\/td>\n9<\/td>\n9<\/td>\nTAB (HT)<\/td>\nA horizontal tab that moves the cursor within a row to the next predefined position (Horizontal Tab) Control Character<\/td>\n<\/tr>\n
0001010<\/td>\nA<\/td>\n10<\/td>\nLF<\/td>\nCauses the cursor to jump to the next line (Line Feed) Control Character<\/td>\n<\/tr>\n
0001011<\/td>\nB<\/td>\n11<\/td>\nVT<\/td>\nThe vertical tab lets the cursor jump to a predefined line (Vertical Tab) Control Character<\/td>\n<\/tr>\n
0001100<\/td>\nC<\/td>\n12<\/td>\nFF<\/td>\nRequests a page break (Form Feed) Control Character<\/td>\n<\/tr>\n
0001101<\/td>\nD<\/td>\n13<\/td>\nCR<\/td>\nMoves the cursor back to the first position of the line (Carriage Return) Control Character<\/td>\n<\/tr>\n
0001110<\/td>\nE<\/td>\n14<\/td>\nSO<\/td>\nSwitches to a special presentation (Shift Out) Control Character<\/td>\n<\/tr>\n
0001111<\/td>\nF<\/td>\n15<\/td>\nSI<\/td>\nSwitches the display back to the normal state (Shift In) Control Character<\/td>\n<\/tr>\n
0010000<\/td>\n10<\/td>\n16<\/td>\nDLE<\/td>\nChanges the meaning of the following characters (Data Link Escape) Control Character<\/td>\n<\/tr>\n
0010001<\/td>\n11<\/td>\n17<\/td>\nDC1<\/td>\nControl characters assigned depending on the device used (Device Control) Control Character<\/td>\n<\/tr>\n
0010010<\/td>\n12<\/td>\n18<\/td>\nDC2<\/td>\nControl characters assigned depending on the device used (Device Control) Control Character<\/td>\n<\/tr>\n
0010011<\/td>\n13<\/td>\n19<\/td>\nDC3<\/td>\nControl characters assigned depending on the device used (Device Control) Control Character<\/td>\n<\/tr>\n
0010100<\/td>\n14<\/td>\n20<\/td>\nDC4<\/td>\nControl characters assigned depending on the device used (Device Control) Control Character<\/td>\n<\/tr>\n
0010101<\/td>\n15<\/td>\n21<\/td>\nNAK<\/td>\nNegative response to a request (Negative Acknowledge) Control Character<\/td>\n<\/tr>\n
0010110<\/td>\n16<\/td>\n22<\/td>\nSYN<\/td>\nSynchronizes a data transfer, even if no signals are transmitted (Synchronous Idle) Control Character<\/td>\n<\/tr>\n
0010111<\/td>\n17<\/td>\n23<\/td>\nETB<\/td>\nMarks the end of a transmission block (End of Transmission Block) Control Character<\/td>\n<\/tr>\n
0011000<\/td>\n18<\/td>\n24<\/td>\nCAN<\/td>\nMakes it clear that a transmission was faulty and the data must be discarded (Cancel) Control Character<\/td>\n<\/tr>\n
0011001<\/td>\n19<\/td>\n25<\/td>\nEM<\/td>\nIndicates the end of the storage medium (End of Medium) Control Character<\/td>\n<\/tr>\n
0011010<\/td>\n1A<\/td>\n26<\/td>\nSUB<\/td>\nReplacement for a faulty sign (Substitute) Control Character<\/td>\n<\/tr>\n
0011011<\/td>\n1B<\/td>\n27<\/td>\nESC<\/td>\nInitiates an escape sequence and thus gives the following characters a special meaning (Escape) Control Character<\/td>\n<\/tr>\n
0011100<\/td>\n1C<\/td>\n28<\/td>\nFS<\/td>\nMarks the separation of logical data blocks and is hierarchically ordered: file as the largest unit, file as the smallest unit.(File Separator, Group Separator, Record Separator, Unit Separator) Control Character<\/td>\n<\/tr>\n
0011101<\/td>\n1D<\/td>\n29<\/td>\nGS<\/td>\nMarks the separation of logical data blocks and is hierarchically ordered: file as the largest unit, file as the smallest unit.(File Separator, Group Separator, Record Separator, Unit Separator) Control Character<\/td>\n<\/tr>\n
0011110<\/td>\n1E<\/td>\n30<\/td>\nRS<\/td>\nMarks the separation of logical data blocks and is hierarchically ordered: file as the largest unit, file as the smallest unit.(File Separator, Group Separator, Record Separator, Unit Separator) Control Character<\/td>\n<\/tr>\n
0011111<\/td>\n1F<\/td>\n31<\/td>\nUS<\/td>\nMarks the separation of logical data blocks and is hierarchically ordered: file as the largest unit, file as the smallest unit.(File Separator, Group Separator, Record Separator, Unit Separator) Control Character<\/td>\n<\/tr>\n
0100000<\/td>\n20<\/td>\n32<\/td>\nSP<\/td>\nBlank space (Space) Special Character<\/td>\n<\/tr>\n
0100001<\/td>\n21<\/td>\n33<\/td>\n!<\/td>\nExclamation mark Special Character<\/td>\n<\/tr>\n
0100010<\/td>\n22<\/td>\n34<\/td>\n<\/td>\nOnly quotes above Special Character<\/td>\n<\/tr>\n
0100011<\/td>\n23<\/td>\n35<\/td>\n#<\/td>\nPound sign Special Character<\/td>\n<\/tr>\n
0100100<\/td>\n24<\/td>\n36<\/td>\n$<\/td>\nDollar sign Special Character<\/td>\n<\/tr>\n
0100101<\/td>\n25<\/td>\n37<\/td>\n%<\/td>\nPercentage sign Special Character<\/td>\n<\/tr>\n
0100110<\/td>\n26<\/td>\n38<\/td>\n&<\/td>\nCommericial and Special Character<\/td>\n<\/tr>\n
0100111<\/td>\n27<\/td>\n39<\/td>\n<\/td>\nApostrophe Special Character<\/td>\n<\/tr>\n
0101000<\/td>\n28<\/td>\n40<\/td>\n(<\/td>\nLeft bracket Special Character<\/td>\n<\/tr>\n
0101001<\/td>\n29<\/td>\n41<\/td>\n)<\/td>\nRight bracket Special Character<\/td>\n<\/tr>\n
0101010<\/td>\n2A<\/td>\n42<\/td>\n*<\/td>\nAsterisk Special Character<\/td>\n<\/tr>\n
0101011<\/td>\n2B<\/td>\n43<\/td>\n+<\/td>\nPlus symbol Special Character<\/td>\n<\/tr>\n
0101100<\/td>\n2C<\/td>\n44<\/td>\n,<\/td>\nComma Special Character<\/td>\n<\/tr>\n
0101101<\/td>\n2D<\/td>\n45<\/td>\n–<\/td>\nDash Special Character<\/td>\n<\/tr>\n
0101110<\/td>\n2E<\/td>\n46<\/td>\n.<\/td>\nFull stop Special Character<\/td>\n<\/tr>\n
0101111<\/td>\n2F<\/td>\n47<\/td>\n\/<\/td>\nForward slash Special Character<\/td>\n<\/tr>\n
0110000<\/td>\n30<\/td>\n48<\/td>\n0<\/td>\nNumbers<\/td>\n<\/tr>\n
0110001<\/td>\n31<\/td>\n49<\/td>\n1<\/td>\nNumbers<\/td>\n<\/tr>\n
0110010<\/td>\n32<\/td>\n50<\/td>\n2<\/td>\nNumbers<\/td>\n<\/tr>\n
0110011<\/td>\n33<\/td>\n51<\/td>\n3<\/td>\nNumbers<\/td>\n<\/tr>\n
0110100<\/td>\n34<\/td>\n52<\/td>\n4<\/td>\nNumbers<\/td>\n<\/tr>\n
0110101<\/td>\n35<\/td>\n53<\/td>\n5<\/td>\nNumbers<\/td>\n<\/tr>\n
0110110<\/td>\n36<\/td>\n54<\/td>\n6<\/td>\nNumbers<\/td>\n<\/tr>\n
0110111<\/td>\n37<\/td>\n55<\/td>\n7<\/td>\nNumbers<\/td>\n<\/tr>\n
0111000<\/td>\n38<\/td>\n56<\/td>\n8<\/td>\nNumbers<\/td>\n<\/tr>\n
0111001<\/td>\n39<\/td>\n57<\/td>\n9<\/td>\nNumbers<\/td>\n<\/tr>\n
0111010<\/td>\n3A<\/td>\n58<\/td>\n:<\/td>\nColon Special characters<\/td>\n<\/tr>\n
0111011<\/td>\n3B<\/td>\n59<\/td>\n;<\/td>\nSemicolon Special characters<\/td>\n<\/tr>\n
0111100<\/td>\n3C<\/td>\n60<\/td>\n<<\/td>\nSmall than bracket Special characters<\/td>\n<\/tr>\n
0111101<\/td>\n3D<\/td>\n61<\/td>\n=<\/td>\nEquals sign Special characters<\/td>\n<\/tr>\n
0111110<\/td>\n3E<\/td>\n62<\/td>\n><\/td>\nBigger than symbol Special characters<\/td>\n<\/tr>\n
0111111<\/td>\n3F<\/td>\n63<\/td>\n?<\/td>\nQuestion mark Special characters<\/td>\n<\/tr>\n
1000000<\/td>\n40<\/td>\n64<\/td>\n@<\/td>\nAt symbol Special characters<\/td>\n<\/tr>\n
1000001<\/td>\n41<\/td>\n65<\/td>\nA<\/td>\nCapital letters<\/td>\n<\/tr>\n
1000010<\/td>\n42<\/td>\n66<\/td>\nB<\/td>\nCapital letters<\/td>\n<\/tr>\n
1000011<\/td>\n43<\/td>\n67<\/td>\nC<\/td>\nCapital letters<\/td>\n<\/tr>\n
1000100<\/td>\n44<\/td>\n68<\/td>\nD<\/td>\nCapital letters<\/td>\n<\/tr>\n
1000101<\/td>\n45<\/td>\n69<\/td>\nE<\/td>\nCapital letters<\/td>\n<\/tr>\n
1000110<\/td>\n46<\/td>\n70<\/td>\nF<\/td>\nCapital letters<\/td>\n<\/tr>\n
1000111<\/td>\n47<\/td>\n71<\/td>\nG<\/td>\nCapital letters<\/td>\n<\/tr>\n
1001000<\/td>\n48<\/td>\n72<\/td>\nH<\/td>\nCapital letters<\/td>\n<\/tr>\n
1001001<\/td>\n49<\/td>\n73<\/td>\nI<\/td>\nCapital letters<\/td>\n<\/tr>\n
1001010<\/td>\n4A<\/td>\n74<\/td>\nJ<\/td>\nCapital letters<\/td>\n<\/tr>\n
1001011<\/td>\n4B<\/td>\n75<\/td>\nK<\/td>\nCapital letters<\/td>\n<\/tr>\n
1001100<\/td>\n4C<\/td>\n76<\/td>\nL<\/td>\nCapital letters<\/td>\n<\/tr>\n
1001101<\/td>\n4D<\/td>\n77<\/td>\nM<\/td>\nCapital letters<\/td>\n<\/tr>\n
1001110<\/td>\n4E<\/td>\n78<\/td>\nN<\/td>\nCapital letters<\/td>\n<\/tr>\n
1001111<\/td>\n4F<\/td>\n79<\/td>\nO<\/td>\nCapital letters<\/td>\n<\/tr>\n
1010000<\/td>\n50<\/td>\n80<\/td>\nP<\/td>\nCapital letters<\/td>\n<\/tr>\n
1010001<\/td>\n51<\/td>\n81<\/td>\nQ<\/td>\nCapital letters<\/td>\n<\/tr>\n
1010010<\/td>\n52<\/td>\n82<\/td>\nR<\/td>\nCapital letters<\/td>\n<\/tr>\n
1010011<\/td>\n53<\/td>\n83<\/td>\nS<\/td>\nCapital letters<\/td>\n<\/tr>\n
1010100<\/td>\n54<\/td>\n84<\/td>\nT<\/td>\nCapital letters<\/td>\n<\/tr>\n
1010101<\/td>\n55<\/td>\n85<\/td>\nU<\/td>\nCapital letters<\/td>\n<\/tr>\n
1010110<\/td>\n56<\/td>\n86<\/td>\nV<\/td>\nCapital letters<\/td>\n<\/tr>\n
1010111<\/td>\n57<\/td>\n87<\/td>\nW<\/td>\nCapital letters<\/td>\n<\/tr>\n
1011000<\/td>\n58<\/td>\n88<\/td>\nX<\/td>\nCapital letters<\/td>\n<\/tr>\n
1011001<\/td>\n59<\/td>\n89<\/td>\nY<\/td>\nCapital letters<\/td>\n<\/tr>\n
1011010<\/td>\n5A<\/td>\n90<\/td>\nZ<\/td>\nCapital letters<\/td>\n<\/tr>\n
1011011<\/td>\n5B<\/td>\n91<\/td>\n[<\/td>\nLeft square bracket Special character<\/td>\n<\/tr>\n
1011100<\/td>\n5C<\/td>\n92<\/td>\n\\<\/td>\nInverse\/backward slash Special character<\/td>\n<\/tr>\n
1011101<\/td>\n5D<\/td>\n93<\/td>\n]<\/td>\nRight square bracket Special character<\/td>\n<\/tr>\n
1011110<\/td>\n5E<\/td>\n94<\/td>\n^<\/td>\nCircumflex Special character<\/td>\n<\/tr>\n
1011111<\/td>\n5F<\/td>\n95<\/td>\n_<\/td>\nUnderscore Special character<\/td>\n<\/tr>\n
1100000<\/td>\n60<\/td>\n96<\/td>\n`<\/td>\nGravis (backtick) Special character<\/td>\n<\/tr>\n
1100001<\/td>\n61<\/td>\n97<\/td>\na<\/td>\nLowercase letters<\/td>\n<\/tr>\n
1100010<\/td>\n62<\/td>\n98<\/td>\nb<\/td>\nLowercase letters<\/td>\n<\/tr>\n
1100011<\/td>\n63<\/td>\n99<\/td>\nc<\/td>\nLowercase letters<\/td>\n<\/tr>\n
1100100<\/td>\n64<\/td>\n100<\/td>\nd<\/td>\nLowercase letters<\/td>\n<\/tr>\n
1100101<\/td>\n65<\/td>\n101<\/td>\ne<\/td>\nLowercase letters<\/td>\n<\/tr>\n
1100110<\/td>\n66<\/td>\n102<\/td>\nf<\/td>\nLowercase letters<\/td>\n<\/tr>\n
1100111<\/td>\n67<\/td>\n103<\/td>\ng<\/td>\nLowercase letters<\/td>\n<\/tr>\n
1101000<\/td>\n68<\/td>\n104<\/td>\nh<\/td>\nLowercase letters<\/td>\n<\/tr>\n
1101001<\/td>\n69<\/td>\n105<\/td>\ni<\/td>\nLowercase letters<\/td>\n<\/tr>\n
1101010<\/td>\n6A<\/td>\n106<\/td>\nj<\/td>\nLowercase letters<\/td>\n<\/tr>\n
1101011<\/td>\n6B<\/td>\n107<\/td>\nk<\/td>\nLowercase letters<\/td>\n<\/tr>\n
1101100<\/td>\n6C<\/td>\n108<\/td>\nl<\/td>\nLowercase letters<\/td>\n<\/tr>\n
1101101<\/td>\n6D<\/td>\n109<\/td>\nm<\/td>\nLowercase letters<\/td>\n<\/tr>\n
1101110<\/td>\n6E<\/td>\n110<\/td>\nn<\/td>\nLowercase letters<\/td>\n<\/tr>\n
1101111<\/td>\n6F<\/td>\n111<\/td>\no<\/td>\nLowercase letters<\/td>\n<\/tr>\n
1110000<\/td>\n70<\/td>\n112<\/td>\np<\/td>\nLowercase letters<\/td>\n<\/tr>\n
1110001<\/td>\n71<\/td>\n113<\/td>\nq<\/td>\nLowercase letters<\/td>\n<\/tr>\n
1110010<\/td>\n72<\/td>\n114<\/td>\nr<\/td>\nLowercase letters<\/td>\n<\/tr>\n
1110011<\/td>\n73<\/td>\n115<\/td>\ns<\/td>\nLowercase letters<\/td>\n<\/tr>\n
1110100<\/td>\n74<\/td>\n116<\/td>\nt<\/td>\nLowercase letters<\/td>\n<\/tr>\n
1110101<\/td>\n75<\/td>\n117<\/td>\nu<\/td>\nLowercase letters<\/td>\n<\/tr>\n
1110110<\/td>\n76<\/td>\n118<\/td>\nv<\/td>\nLowercase letters<\/td>\n<\/tr>\n
1110111<\/td>\n77<\/td>\n119<\/td>\nw<\/td>\nLowercase letters<\/td>\n<\/tr>\n
1111000<\/td>\n78<\/td>\n120<\/td>\nx<\/td>\nLowercase letters<\/td>\n<\/tr>\n
1111001<\/td>\n79<\/td>\n121<\/td>\ny<\/td>\nLowercase letters<\/td>\n<\/tr>\n
1111010<\/td>\n7A<\/td>\n122<\/td>\nz<\/td>\nLowercase letters<\/td>\n<\/tr>\n
1111011<\/td>\n7B<\/td>\n123<\/td>\n{<\/td>\nLeft curly bracket Special characters<\/td>\n<\/tr>\n
1111100<\/td>\n7C<\/td>\n124<\/td>\nl<\/td>\nVertical line Special characters<\/td>\n<\/tr>\n
1111101<\/td>\n7D<\/td>\n125<\/td>\n}<\/td>\nRight curly brackets Special characters<\/td>\n<\/tr>\n
1111110<\/td>\n7E<\/td>\n126<\/td>\n~<\/td>\nTilde Special characters<\/td>\n<\/tr>\n
1111111<\/td>\n7F<\/td>\n127<\/td>\nDEL<\/td>\nDeletes a character. Since this control character consists of the same number on all positions, during the typewriter era it was possible to invalidate another character by punching out all the positions (Delete) Control characters<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\ucc38\uace0 : https:\/\/www.ionos.com\/digitalguide\/server\/know-how\/ascii-codes-overview-of-all-characters-on-the-ascii-table\/<\/a><\/p>\n
\uc784\ud314\ub77c\uc5d0\uc11c \uc544\ub798\uc640 \uac19\uc774 \ucffc\ub9ac\ud574\ubcf4\uba74 \uc544\uc2a4\ud0a4\ucf54\ub4dc \uc21c\uc11c\ub300\ub85c \uc815\ub82c\ub418\ub294 \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/p>\n
select *\n  from (select chr(32) as c, 32 as n union all \n        select chr(33) as c, 33 as n union all \n        select chr(34) as c, 34 as n union all \n        select chr(35) as c, 35 as n union all \n        select chr(36) as c, 36 as n union all \n        select chr(37) as c, 37 as n union all \n        select chr(38) as c, 38 as n union all \n        select chr(39) as c, 39 as n union all \n        select chr(40) as c, 40 as n\n       ) a\n order by c asc<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
rpad \ubb38\ubc95\uc740 rpad(A,N,B) \uc640 \uac19\uc774 \uc37c\uc744 \ub54c, \uc804\uccb4 \ubb38\uc790\uc5f4 \uae38\uc774\uac00 N \ub9cc\ud07c \ub418\ub3c4\ub85d B \ubb38\uc790\uc5f4\uc744 \ubd99\uc5ec\uc900\ub2e4. \ub54c\ubb38\uc5d0 fixed-width \uceec\ub7fc\uc758 \uac12\uc774\ub098 \uac80\uc0c9 \uc870\uac74\uc744 \ub9cc\ub4e4\uc5b4\ub0b4\ub294 \ub370\uc5d0 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4. \uc6b0\ub9ac \uc2dc\uc2a4\ud15c\uc5d0\uc11c\ub294 \ud2b9\uc815 \uc774\ubca4\ud2b8\ub97c \uc2dd\ubcc4\ud558\uae30 \uc704\ud574\uc11c \ub9e8 \uc55e \uc5f4 \uc5ec\uc12f \uc790\ub9ac\ub294 \ud574\ub2f9 \uc774\ubca4\ud2b8 \ubc1c\uc0dd \uc2dc\uac04\uc774\uba74\uc11c 33 \uc790\ub9ac\uc778 id\ub97c \ud0a4\ub85c \uc0ac\uc6a9\ud558\uace0 \uc788\ub294\ub370 \uc774 \ub54c\uc5d0 rpad \ub97c \ud65c\uc6a9\ud558\uba74 \uc720\uc6a9\ud558\ub2e4. \ud2b9\uc815 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[161,160],"tags":[],"class_list":["post-1533","post","type-post","status-publish","format-standard","hentry","category-impala","category-sql"],"_links":{"self":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/1533","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/comments?post=1533"}],"version-history":[{"count":0,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/1533\/revisions"}],"wp:attachment":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/media?parent=1533"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/categories?post=1533"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/tags?post=1533"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}