@test script@
select *
from   dual
@scott zijn employees@
select * from scott.emp
@TESTE@
SELECT SUM(1)
FROM INDICADORES_FINANCEIROS
@PROCURAR_COLUNA@
SELECT *
FROM USER_COL_COMMENTS
WHERE (   TABLE_NAME LIKE 'CIM%'
       OR TABLE_NAME LIKE 'CAM~_%' ESCAPE '~' 
      )
  AND (COLUMN_NAME LIKE upper('%&TEXTO%')
       or
       upper(COMMENTS) LIKE upper('%&TEXTO%')
      )
  
   
@emabarque_segurado@
select sepr.cd_segurado_principal, 
       segd.nm_segurado, 
       decode(segd.fl_status, 1, 'Ativo',
                         2, 'Inativo', 
                         3, 'Prospect') fl_status 
from  sas.tb_segurado segd,
      sas.tb_segurado_principal sepr
where segd.fl_status <> 3
  and segd.cd_segurado_principal = sepr.cd_segurado_principal
  and sepr.cd_segurado_principal =451
order by 2
@tb_embarque - selecao@
select * 
from tb_embarque a
where a.nu_ano_embarque = 2003
  and a.nu_mes_embarque = 11  
  and a.cd_ramo         =54
  and a.cd_segurado     =21
  
select * from tb_ramo
where nm_apelido='RCTR-C'
