Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jadexy

    graphical user interfaces

    Hallo, I don't know if I'm in the right forum and this is the right headline. What I'm looking for is something where I can develop my oracle database when I use the geometry features. I have experiences with sql*plus for creating tables/types/triggers/sequences/function ... for my database...
  2. jadexy

    SQL update problem

    Hallo, thanks for your advice. Now I change my query to this update flurstuecke_tab f set f.gemark_schluessel=(select ref(s) from gemark_schluessel_tab s where s.gemark_schl=f.gemark_schl); and it works fine. Thanks Tig
  3. jadexy

    SQL*LOADER and REF COLUMN

    Hallo William, this is my script I load with SQL*LOADER LOAD DATA INFILE * TRUNCATE CONTINUEIF NEXT(1:1) = '#' INTO TABLE FLURSTUECKE_TAB FIELDS TERMINATED BY '|' TRAILING NULLCOLS ( flst_id, flst_nr_zaehler, flst_nr_nenner, zusatz, flur_nr, gemark_schluessel...
  4. jadexy

    SQL update problem

    Because it doesn't worked I have added a new attribute in flurstuecke_t gemark_schl and I wanted to update after the load (which worked fine) but the statement didn't work.
  5. jadexy

    SQL update problem

    Hallo, originally that are my types and tables. -- Gemarkschluessel CREATE TYPE gemark_schluessel_t AS OBJECT( gemark_id NUMBER(8), gemark_schl NUMBER(4), gemark_name VARCHAR2(45) ); / CREATE TABLE gemark_schluessel_tab OF gemark_schluessel_t( constraint pk_gemark PRIMARY KEY(gemark_id) )...
  6. jadexy

    SQL update problem

    Hallo, I have already posted and didn't come further. So I tried another way and added and attribute gemark_schl to my table flurstuecke_tab. Now I have this 2 tables: SQL> desc flurstuecke_tab Name Null? Type -----------------------------------------...
  7. jadexy

    SQL*LOADER and REF COLUMN

    Hallo, I have already posted and hope somebody can help me. I have the following problem. I have 2 tables which I created the following way: CREATE TYPE gemark_schluessel_t AS OBJECT( gemark_id NUMBER(8), gemark_schl NUMBER(4), gemark_name VARCHAR2(45) ); / CREATE TABLE gemark_schluessel_tab...
  8. jadexy

    SQL update Problem

    Hallo, I have 2 tables: SQL> desc flurstuecke_tab Name Null? Type ----------------------------------------- -------- ---------------------------- FLST_ID NOT NULL NUMBER(8) FLST_NR_ZAEHLER...

Part and Inventory Search

Back
Top