lunedì 18 dicembre 2017
SQL ORACLE: Trasformare stringa in tabella
SELECT Replace(CAMPO,'''','') CAMPO FROM (
SELECT * FROM dual PIVOT ( COUNT(*) FOR (DUMMY) IN ( 'CNR1','321G','321H','321I' ))) mytab
UNPIVOT INCLUDE NULLS ( VAL FOR( CAMPO ) IN ( "'CNR1'","'321G'","'321H'","'321I'" ) );
Iscriviti a:
Post (Atom)
-
The illustration below shows a script tool dialog box with three parameters: an input workspace, a clip feature class, and an output ...
-
https://www.pcjs.org/software/pcx86/sys/windows/3.10/
