Re: Select data prior to a character in a row?

On Jan 5, 5:04 pm, Michael Austin <maus...@xxxxxxxxxxxxxxxxxx> wrote:
Ed Prochak wrote:
On Jan 3, 4:20 pm, DP <dxpe...@xxxxxxxxx> wrote:
On Jan 3, 1:04 pm, Walt <walt_ask...@xxxxxxxxxxxxxx> wrote:

DP wrote:
Our CMDB database (vendor supplied) stores information in a
singlevarchar2 field.
The DATA:
Name
-----------------------------------------------------------
MPORTWEB03(MPORTWEB03) : msdb
MPORTWEB03(MPORTWEB03) : pubs
MPORTWEB03(MPORTWEB03) : tempdb
pr04(droid) : DAFRANZ
pr04(droid) : DAMOLSO
pr04(droid) : DAQUINT
pr04(droid) : DBSNMP
What I can't figure out is how to select data up to or before the
first open paran.
I have tried RTIRM with no luck.
Immediate solution:  use the built in SUBSTR and INSTR functions to
extract the appropriate substrings. i.e. something like
    select substr(name,0,instr(name,'(')-1) from table;
Better solution: create view(s) and or procs using the functions above
to allow you to query the table like a human being
Best solution: ditch this abortion of a data design and replace it with
something designed by someone with a clue.
Good luck!
//Walt- Hide quoted text -
- Show quoted text -
Thanks!!!

I agree with you 100%. I would love to ditch this CMDB vendor, but
that is not my call..  I just have to make it work!  :-)

Dennis

Why do you have to "make it work"??   That should be the vendor's job!
(exactly what product/vendor is this anyway?
 They deserve to be tarred and feathered!)

  Ed

:) most of them do deserver to be tarred and feathered.

It looks like they hire kids with no experience what-so-ever and then
wonder why in the world it doesn't work/scale/.... Just because you "can
do it that way" doesn't mean that you should....- Hide quoted text -

- Show quoted text -


These are the reporting tables,It gets worse.. The CMDB tables use
longs/clobs to store data.
The report we are writing is outside of the normal web application, so
the vendor would not help solve this issue.


I don't think are many vendor application that even come close to
using a decent data model.
Our DBA's do spend some time on trying to get applications to
perform..

I appreciate everyone's comments and help!
Dennis



.

Relevant Pages

  • Re: Did Ken Fortenberry actually say this? Or was this forged? Does he admit to writing this and mai
    ... They of course deserve credit and lots of it. ... heroic in their eforts and serve their country well and they and their ... My Lai village had about 700 residents. ... reporting in the White House to the ...
    (rec.music.gdead)
  • [Full-Disclosure] Re: its all about timing
    ... see folks asking in various lists "how do I contact such&such vendor to ... vulnerability reports in the various lists where the vendor had not ... times now has M$ changed it's vulnerability/security issues reporting ... > reported security issue and direct it to the Security Response ...
    (Full-Disclosure)
  • [Full-Disclosure] Re: its all about timing
    ... >that vendor in private, ... variety in how professionals handle vulnerability reporting. ... the current RVDP draft already has a number of ... Vendor of vulnerabilities. ...
    (Full-Disclosure)
  • RE: Vulnerabilities in some SCADA server softwares
    ... Where I take issue is with the false notion that public reporting leads to ... whether that threat is limited to clean rooms or public-facing ... by a vendor, neither the underlying problems that cause the vulnerability ... Vulnerabilities in some SCADA server softwares ...
    (Bugtraq)
  • Re: [PATCH] x86: CPU detection for RDC System-on-Chip
    ... reporting things to LKML is very ... different board flavors which register platform devices for the various models ... Having this detection logic based on the RDC model is ... vendor firmware header. ...
    (Linux-Kernel)