The effect of sql-oracle in the realization of the column schema

In SQL Server, there is a function replicate () can implement the column chart effect, essentially using the number of occurrences of characters to control the length of the column chart, the effect

If you want to achieve the same effect within Oracle, you need to write a function yourself:

CREATE OR REPLACE FUNCTION kthis. REPLICATE (NO in number)
RETURN VARCHAR2
/**********************
Create by Yggdrasil
***************************/
As
V_return VARCHAR2 (500);
V_count number;
BEGIN
V_count:=1;
v_return:= ' = ';
IF No<0 Then
V_return:= ";
Elsif No<=1 Then
v_return:= ' = ';
Elsif No>1 Then
LOOP
v_count:=v_count+1;
SELECT v_return| | ' = ' into V_return from DUAL;
EXIT when v_count>no;
END LOOP;
END IF;
RETURN V_return;
END;
/

Then call the function to achieve the effect, you can simply display some data changes ^_^

The effect of sql-oracle in the realization of the column schema