Oracle �ŊȒP�_�O���t�\��

Oracle �� SQL �ŊȒP�ɖ_�O���t����鏬�l�^�ł��B

�\������̂��߂� COLUMN �Ƃ����g���Ă��܂��� �|�C���g�� LPAD �֐��̎g�����ł��B

SQL> COLUMN TNAME FORMAT A30
SQL> COLUMN BAR   FORMAT A30

SQL> SELECT tname, LPAD('*', LENGTH(tname), '*') AS bar FROM TAB;

TNAME                          BAR
------------------------------ ------------------------------
W_AB_T_OPTAR_POLOLOPL_CLOSED   ****************************
W_START                        *******
E_AB_T_PLANT                   ************
E_AB_T_EERCC_BODY              *****************
E_AB_T_EERCC_HEAD              *****************
E_AB_PLANT_DATA                ***************
E_AB_KUJIDE_BODY               ****************
E_AB_KUJIDE_HEAD               ****************
R_AB_T_OPTAR_CLOSED            *******************
R_AB_T_OPTAR_KAMOKU            *******************
R_AB_KK_DATA                   ************

���̃T���v���̓e�[�u���̖��O�̒����Ƃ��� ���Ȃ�ǂ��ł��ǂ����̂�_�O���t�ɂ��Ă܂��� �i�_�O���t�����Ȃ��Ă����̂܂܂ł����j�A �_�O���t�����邱�Ƃ� �����₷���Ȃ���̂͌��\����Ǝv���܂��B

Google �T�C�g������

Amazon�A�\�V�G�C�g