Skip to main content

Posts

Showing posts with the label Generate Astrix lines by select query in oracle

Generate Astrix lines by select query in oracle

If you want to generate Astrix lines by select query in oracle this way. ♥ ♥♥ ♥♥♥ ♥♥♥♥ ♥♥♥♥♥ ♥♥♥♥♥♥ ♥♥♥♥♥♥♥ ♥♥♥♥♥♥♥♥ ♥♥♥♥♥♥♥♥♥ ♥♥♥♥♥♥♥♥♥♥ ♥♥♥♥♥♥♥♥♥♥♥ Then you can try following query SELECT LPAD(CHR(3),LEVEL,CHR(3)) "KEEP LOVING ORACLE " FROM DUAL 2* CONNECT BY LEVEL<=11