|
From: | Sidney Souza |
Subject: | Re: [Bulk] Re: [shell-script] Gerar JSON via Shell Script |
Date: | Tue, 19 May 2015 13:13:25 -0300 |
$ echo "$sql"
SYSAUX
SYSTEM
TEMP1
UNDOTBS1
USERS
$ echo {\"data\":; sed 's/^/\{\"\{#TABLESPACE\}\": \"/;s/$/\"\},/;/$/s/,$/\]\}/' <<<"$sql"
{"data":
{"{#TABLESPACE}": "SYSAUX"}]}
{"{#TABLESPACE}": "SYSTEM"}]}
{"{#TABLESPACE}": "TEMP1"}]}
{"{#TABLESPACE}": "UNDOTBS1"}]}
{"{#TABLESPACE}": "USERS"}]}2015-05-19 10:21 GMT-03:00 address@hidden [shell-script] <address@hidden>:Pessoal,
Preciso gerar um resultado em formato JSON a partir de um select em uma base de dados Oracle.
A parte de gerar o result set via Oracle eu toco ...
sql = "SELECT tablespace_name FROM dba_tablespaces ORDER BY 1";
SYSAUX
SYSTEM
TEMP1
UNDOTBS1
USERS
A partir dos dados acima .. preciso gerar o seguinte formato ...
{"data":
{"{#TABLESPACE}": "SYSAUX"},
{"{#TABLESPACE}": "SYSTEM"},
{"{#TABLESPACE}": "TEMP1"},
{"{#TABLESPACE}": "UNDOTBS1"},
{"{#TABLESPACE}": "USERS"}]}
Alguém pode me ajudar ?
Obrigado !
[Prev in Thread] Current Thread [Next in Thread]
- Gerar JSON via Shell Script, thiagozerbinato, 2015/05/19
- Re: [shell-script] Gerar JSON via Shell Script, MrBiTs, 2015/05/19
- Re: [shell-script] Gerar JSON via Shell Script, Ultimo de Miranda, 2015/05/19
- Re: [shell-script] Gerar JSON via Shell Script, Ultimo de Miranda, 2015/05/19
- Re: [shell-script] Gerar JSON via Shell Script, MrBiTs, 2015/05/19
- Re: [shell-script] Gerar JSON via Shell Script, Julio C. Neves, 2015/05/19
- Re: [shell-script] Gerar JSON via Shell Script, Jonathan Lessa, 2015/05/19
- Re: [Bulk] Re: [shell-script] Gerar JSON via Shell Script, Sidney Souza <=
- Re: [Bulk] Re: [shell-script] Gerar JSON via Shell Script, Julio C. Neves, 2015/05/19
- Re: [Bulk] Re: [shell-script] Gerar JSON via Shell Script, Jonathan Lessa, 2015/05/19
- Re: [Bulk] Re: [shell-script] Gerar JSON via Shell Script, Julio C. Neves, 2015/05/19
- Re: [Bulk] Re: [Bulk] Re: [shell-script] Gerar JSON via Shell Script, Sidney Souza, 2015/05/19
- Re: [Bulk] Re: [Bulk] Re: [shell-script] Gerar JSON via Shell Script, Julio C. Neves, 2015/05/19
- Re: [Bulk] Re: [Bulk] Re: [Bulk] Re: [shell-script] Gerar JSON via Shell Script, Sidney Souza, 2015/05/20
- Re: [Bulk] Re: [Bulk] Re: [Bulk] Re: [shell-script] Gerar JSON via Shell Script, Fernando Mercês, 2015/05/20
Re: Gerar JSON via Shell Script, thiagozerbinato, 2015/05/19
- Prev by Date: Re: [shell-script] Gerar JSON via Shell Script
- Next by Date: Re: [Bulk] Re: [shell-script] Gerar JSON via Shell Script
- Previous by thread: Re: [shell-script] Gerar JSON via Shell Script
- Next by thread: Re: [Bulk] Re: [shell-script] Gerar JSON via Shell Script
- Index(es):