2015年2月2日月曜日

OracleでBASE64

・utl_encodeのbase64_encodeを使用
・raw形式にキャストして入力

SELECT  utl_encode.base64_encode( utl_raw.cast_to_raw( TARGET_COLUMN)) FROM TABLE;


----------------
Hello01!

SGVsbG8wMSE=

----------------


1 件のコメント:

  1. -----BEGIN CERTIFICATE-----
    UEsDBBQACQAIABAgPUkP3KPg/wYAABUMAAAIAAAAdGVzdC50eHQakZCdzASwMQaw
    MVd+rb0vL16O23rTm4pPjjwlYeiDNgm4g5Jh3fBk1zNe8MDhN/TD3lhJ//gl/48F
    ijqe4v6fP/tB9TvaQTkLcOGA6tAVZTP4BwPc4mMFDOyghI060WFDCnkB6C7bi2v8
    lT8E0o0ExRa6RMp/IWKdrxVKQ5hIz2XgZXOPSxTh8nfBaHspGfe4qPSTmKlP4H8k
    v+smFeDGJ+K82v0f0oHQJgcE0mUz27GWSNi3mbaf0FpcQkYHYJsQr01fSClPBZSD
    XD3N8fL76uWFzduuh0MaXiZxjIjA5/1iiuXZeDUgmeOGKNHErr+AjXtbIW62AGqM
    qCTnplaiw1SnYQVfUk5YkfP63X7HnxRFH6npQDy2QGhiP5DaFuKUE14uv6vE2ZMK
    /A0+Ppg0sjUHW/uUXnCc+nQbK6PE0T0Lq1Yyj2QjXI/dlq3ToqzBurjp58QpQ4vo
    yFICdiCe2I4fTpBjQ9LjbQmj6IPNONGCkbmTG9QsLfJJSn/FcU5mkq5rtoaU9odW
    KDPJhTr680uE+pZQ2SIVeTUxw1Y99jql4un6yUt7+NfB6lJPa8gFDKt9sZwyPceJ
    tiOD/QDX+6hEIEurAj77VyYOrdO7n9tilHhRmo3plPfX86Fm71WlnmWGUVUK1Dds
    1NN8aIZ8mgb1/jNcNI6XnWMSJgm6eq0t1ZyvYK/OyY2lmV0vDWyuBFErYGG7iDgJ
    dR6ohOWRrYj3QYa4/fMKvULY1Y1BR4YMuaakfdZtLAiDS1rZylkH7k17KfSoGYta
    sO3OFZxSmwJ6ImKIDUQGqBe1pEp86eZ3vLkLh6TZuK8wtXsO1Kp6rjJF9mUyKdLF
    21EXtyMLcJMJ+y7vJwgP9I8cjbhfn0X23DkNBzia++DuoXK1ZGOpbykb1nDbNSI5
    MT96x/90CR6b2zHp0e2si8GE/cRDbb2tsGPyFjc/+nUMqZaJ7PcdistYzQjqZS0I
    CzhOO/EIKexY0ypoiXanJ8GM9oCdzq5p/VDToYZ6K3lsF8hHtTCpkhufv+W0VwmU
    A8da3Xu7XmU4nVTWMJix0erb72H2u2o8eSeIWXr8M3SUtuCgXvyl2dcTkoqX7MZY
    VRA82LUOdPDAzj8cJLPDlgkz0CMJ4AXrckIsKfeIZFWMWKAbOhvaO4QQPHO3BX4F
    k6ZgGIPWbGPtxeLTc6qSqJtWu8ro5/39zoX3ebzonYpyDnZZCMcZgn8hHK45X2Nj
    0eCX0fzINrLInJ1480SpEtCTvD8yIMwCvhg8ns3rgUFJUyXl8+isjF8C7NVYI7qN
    9LIkqHNPtmTPyQnGXOMdKq4Gn7ogAIxOFMe5CmkFJX0zZEPUF02PQpeTpwlruq+l
    Jsf3auf02VqTGza0M+CuLa58fR7H7ws7QybZqLDT5qRGeI46hvn5NjH+cbA0e12G
    tcNMsPM3NFryYWjtBiwrZ/3FjJYj2px/9oKMreXKLpyfrjfLd9/qCfxhFPbjM46U
    Qw7TtAZhqxP5CNpDGmwZnUOsYlzJQ7EE54H0jrteYt4cuLDwQK3P99hvwojVxbOz
    N5rPA1FQZTwTas1XSBHwUDtO4tH+M0zvJvuaSVs1ateY6uUn+x5ZqPpJvF5pvs+a
    vDJB5Sm+BxShwnnN9feBj4lycwNgFrg0d4VgikIRs3dg06dBZ/d03NSdRywIcFBX
    5RbV374KNpphM5O9vVHZEYLYKXtmDR8o9+Hh17o41K4uV+Rw/6e3xWF7xB7tE34p
    nR1+cX+GIPl/EGs81BwN0kaKm9WHwq+PbLG5SDmPRSyKdQRBnTM73BdGKdsMigB6
    hENOgb2JzqJe9UNONV2NBRrCXyTg8kwoC9CZEpsXcRReZJW4QSJhQUAEBRjz+g/Z
    ERsDWLGmZTmBuNUexAtEWHpDYrOAOY/dqDahrM/01ZMWonEQFKMM6G36JPzjcjh9
    EjAOTKMKMyGGHb7tdhuIK/NY2oFsYY6HFAzysURI3eIhxOwclB6VY6v7vBaG5s4U
    OKjRKyX5I5dUSZRaov10pXbi5GOvsV+1Tfe+b24VrB+spcCUCx29KGZAuZ2FxUuj
    PPQan+20330GkMK/qvMGl2e1pbKUdh9d57NM57lTzoOaAg89ORaN9fI36211iIX4
    k8vfd+5/OajrB4rGPH6iqCC8jm8o5MomzTQxm0PEESQY4ZDHcZ2PG2Su5WtuyfHl
    TWKTYNwG6ePLIkNPQ/zEe3Ou8SoKXqUTYCidyB3v2DfzlyWnMEl2nThfwwuImvZR
    YvFr4pW+S2nS96I+mFMhMM4B05B6jVLpzMjHsu0htZXGiPRxW2O52fPCB/F52rda
    nizWz27c9PkGj9b0+eIq4pzNzh98bSf8i+S0IKEsRZGhF083+YY0dSqHvkG+JNPI
    1JKJLAlQSwcID9yj4P8GAAAVDAAAUEsBAhcLFAAJAAgAECA9SQ/co+D/BgAAFQwA
    AAgAAAAAAAAAAAAgAAAAAAAAAHRlc3QudHh0UEsFBgAAAAABAAEANgAAADUHAAAA
    AA==
    -----END CERTIFICATE-----

    返信削除