Tag Archive: query

Retrive sqldata through shell script
  • 18
    Mar

Retrive sqldata through shell script

It could be useful get data from DB by a  bash script Linux. Using a shell Bash is possible to create the following query: dir_in=`sqlplus -s $PMS_CONN_STRING <<EOF SET PAGESIZE 0 FEEDBACK OFF VERIFY OFF HEADING OFF ECHO OFF select...

Read More
Oracle glossary: Subquery
  • 23
    Set

Oracle glossary: Subquery

Oracle subquery is a sql query within another sql query. Some example: select tab.name, tab.surname from (select name, surname from customer where surname like ‘S%’) tab select id from myusers where (name, surname) in (select name, surname from customer where...

Read More
Access problem NOT IN query using db link on db 9i:select id_bda
  • 10
    Lug

Access problem NOT IN query using db link on db 9i:select id_bda

from anag_li where id_bda not in (select idanag from prova@bdlink); Access plan: ------------------------------------------------------------------------------------ | Id  | Operation            |  Name       | Rows  | Bytes | Cost  | Inst   |IN-OUT| ------------------------------------------------------------------------------------ |   0 | SELECT STATEMENT     |             | 37490 |   585K|   978K|       ...

Read More
Retrive sqldata through shell script
  • 17
    Giu

Retrive sqldata through shell script

It could be useful get data from DB by a  bash script Linux. Using a shell Bash is possible to create the following query: dir_in=`sqlplus -s $PMS_CONN_STRING <<EOF SET PAGESIZE 0 FEEDBACK OFF VERIFY OFF HEADING OFF ECHO OFF select...

Read More