Recent content by Roberto

Hi, with a server test, i've migrate on oracle 9.2 and on my pc client i've installed oracle client 9.2 with all XML option. Now i've tried to execute a query in this style select XMLElement("Emp", XMLAttributes(e.employee_id AS "ID", e.last_name), XMLElement("Dept",e.dept)...

Hi, i've find something on the web around this function (XMLElement, XMLForest, etc...) but with my oracle 8.1.7 i do not succeed to use them...there is a way to see if this function are included? If there aren't, how i can install this function? Thanks Roberto

Hi, i would to create a xml file containing data extract with a sql query, but xml file must respect a specific dtd (and not the generic schema that i obtain whit the export of the grid). Is the first time that i must export data in a xml and...i'm very confused i work with oracle 8.1.7 and...

Hi, I would have to export data extract with a sql windows in a xml file. Is possible to change the way with which the rows xml it comes created? e.g. If i have the row: Surname | Name | telephone | email Rossi | Mario | 1234 | eg@eg.com actually the file xml will be...

Thank's

Hi, when, from a command windows, I carry out the spool on file, at the end the output file contains the line "executed in xxxx seconds". How I can avoid it? By Roberto

thanks, this command me will be much profit

unfortunately the number of the extracted records is right indeed they would have to be in all 618155, and I cannot avoid it. there is a solution?

Hi, when my query extracts more than 200000 records appears a message of error: "Out of memory". what it depends? I set the buffer, in the preference menu, on the max value...what i do ? p.s.: scuse for my student's english