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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by KL1
-
Oracle XDK Performance Issues
I am using the Oracle XDK to generate xml from the database. A straight forward select from 1 table which would pull back 70 records takes 10 mins to run before falling over as it has run out of tablespace in TEMP files. I have run an explain plan on the select and the cost is only 1 and it is... -
Update of table from .csv file
Thought I might have to do something like that. Thanks for you help. Karen- KL1
- Post #3
- Forum: Oracle: All versions
-
Update of table from .csv file
I need to update specific columns on a table from data held in a csv file. My understanding is that SQL*Loader cannot do this. Is there any quick and easy way to do it or is the best way to use UTL_FILE functionality. Thanks in advance Karen- KL1
- Thread
- Replies: 3
- Forum: Oracle: All versions
-
Validate empty elements against schema
Thanks again. Will get onto the client who passes the file and ensure they do this. Karen -
Validate empty elements against schema
Thanks for that, it has worked for elements declared as strings, however 2 of the elements are dates and 1 is a decimal. Can it be done for these or is best practice to make these elements optional in the file? Karen [ponytails2] -
Validate empty elements against schema
I have an xml file that will initially contain empty elements. When validating this against the schema it does not validate for the reason ' XSD-2025: (Error) Invalid text '' in element: 'DATE_APPLIC_RECD'. I have tried the elements as <DATE_APPLIC_RECD/> and also...
