Recent content by Cantor

The second direction seems interesting. How can you do that? Let's say we have toto.zip to delete form this ftp server : Host name : ftp.sitename.com directory : /data/zipfile Are you saying it's possible to "see" toto.zip with SQL*Plus, and then remove it? Cantor

Sorry to be so unclear. Nothing has been done yet. We are at the "is it possible?" stage. The plan is to execute a DB package who will delete a zip file from a ftp server. So the "tool" would be a PL/SQL procedure store in this package. I hope this will help us to help me, Thanks, Cantor

Hi, we need to delete a file who is on a ftp site. Is there any PL/SQL commands to do that? Does the package UTL_TCP can delete a file? I saw functions like "put" and "get" but no "delete". Thanks for your help, Cantor

Hello, I use the Web.Show_document('My_URL', '_TARGET') in a form to call some reports located on a web server. I always use the target '_BLANK' to open my documents in a new web browser and it works well. My problem is when I want to open more than one document in a row. I call...

Hi, Does someone know how to convert/export a Designer Server Model Diagram in a PDF format? Is it possible? Tanks, Cantor

Hi, Let suppose a single table NAMES First_name VARCHAR2 Last_name VARCHAR2 Is it possible to do a query to show this table ordered by First_name first and, secondly, ordered by descending order of the Last_name in the same query? thanks

Obviously, I try it before to post my question. When I use this syntax (the same as you), I have a inconsistent datatypes error (ORA-00932). The only solution I see is to write a PL/SQL program. I'm trying this way. Thanks

Hi, What I know: If you want to find all records of the table PERSONS where the FIRSTNAME begins with 'Joh' (FIRSTNAME is a VARCHAR2 type column), you do that: SELECT * FROM PERSONS WHERE FIRSTNAME LIKE 'Joh%'; What I ask: How do you do that if the column is defined LONG type instead of...

Hello, I try to insert a table in another table (two tables are exactly the same) but the type of one field of those tables is LONG datatype. So I do: INSERT INTO table1 SELECT * FROM table2@DB_LINK; It gives the alert: ORA-00997: illegal use of LONG datatype How could I solve this...

Sorry for the normalization, I forgot to Preview Post before submit it. The same sample of my table, normalized: Game # winningTeam losingTeam winScore lostScore 1 Tigers Flames 4 3 2 Canucks Tiger 5 2 3...

Hi, There is a sample of my table: Game # winningTeam losingTeam winScore lostScore 1 Tigers Flames 4 3 2 Canucks Tiger 5 2 3 Pens Canucks 6 2 4 Tigers Av's 2 1 My question is simple. I would like to request the sum of winScore and the sum of lostScore for...

Thank you I found this article who is exactly what I need : Q155979

I'll try to give you a better picture, but sorry, i'm not too good in english. I've formatted my hard drive but before this, I partionned him like this c: -> HD_1 and the new one d: -> HD_2. I've made a backup of some files (mydoc.qic) with MS Backup and save it on HD_2. So I formatted the HD_1...

When I want to restore the file, I must import the qic file and then the error message occurs : "The file is not runnable. Erase the file or choose another one." I hope the file is not corrupted or stuff like that. Thanks for response, Cantor

Hi, I have QIC Files from Win 98, now I have Windows 2000 and I can't restore them. How I can made it?. Please help me, I have a lot of important information. Thanks, Cantor