"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3b8e0d84$0$227$ed9e5944_at_reading.news.pipex.net>...
> "Ksous Mekki" <ksousm_at_draexlmaier.de> wrote in message
> news:3b5251eb.0108300019.7b7dcb54_at_posting.google.com...
> > What is the SQL command or the solution, to find stations that their
> > tcp_ips are between (193.50.130.25 and 193.50.130.100).
> > NB: column tcp_ip is type VARCHAR2(15)
>
> THe followings should give you the idea. I have no comment on the efficiency
> of this code
>
> SQL> select * from tab;
>
> IP_COL
> ---------------
> 193.50.30.21
> 193.50.30.26
> 193.50.30.50
> 193.254.30.50
> 193.50.30.50
> 193.50.30.254
>
> 6 rows selected.
>
> SQL> select ip_col from tab
> 2 where substr(ip_col,1,9) = '193.50.30'
> 3 and to_number(substr(ip_col,11,3)) between 25 and 75;
>
> IP_COL
> ---------------
> 193.50.30.26
> 193.50.30.50
> 193.50.30.50
>
> SQL>
salute has all,
I tried of creates a data bank under oracle8 server (to install under
WINNT server) of which the goal of creates a group of 3 or 4 station
customer work oracle is a server.
me follow-up the helper's instructions for the creation of the basis,
but for the last phase this last was not able to started the
OracleServiceTest service. I even tried of started the service creates
by l'orcale8 during the installation, still the same problem. (Could
not start the OracleServiceORCLE service on \\srvora8 error 0126:The
specified module could not be found)
the gait that me follow-up is a can long me not the of writing for the
meantime.
tried if he/it pleases you of given me a solution
Received on Fri Aug 31 2001 - 02:56:54 CDT
