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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- jadexy
- Thread
- Replies: 0
- Forum: Oracle: All versions
-
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- jadexy
- Post #6
- Forum: Oracle: All versions
-
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...- jadexy
- Post #3
- Forum: Oracle: All versions
-
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.- jadexy
- Post #4
- Forum: Oracle: All versions
-
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) )...- jadexy
- Post #3
- Forum: Oracle: All versions
-
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 -----------------------------------------...- jadexy
- Thread
- Replies: 5
- Forum: Oracle: All versions
-
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...- jadexy
- Thread
- Replies: 3
- Forum: Oracle: All versions
-
SQL update Problem
Hallo, I have 2 tables: SQL> desc flurstuecke_tab Name Null? Type ----------------------------------------- -------- ---------------------------- FLST_ID NOT NULL NUMBER(8) FLST_NR_ZAEHLER...- jadexy
- Thread
- Replies: 2
- Forum: Oracle: Enterprise Developer Suite
