Search results for query: *

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

I know how to remove the selected item from list1 but I don't want because datas from list1 come from my main table and I need them for other things. I could create another table for only datas who are in list1, but I don't want because, I've many list box and I would be overloaded by the number...

Hi,<br>I've two list box, list1 and list2. When a user selects an item from list1 and click on a command button, the item is added to list2, without be delete from list1. No problem with that. <br>What I want to do now is when the user will tries to add item from list1 a second time, a message...

Hello,short question: Is it possible to select only the fiel name?shorter question: How?Thanx,Cantor

Hi,In my form I've 2 listbox: ListBox1 and ListBox2. ListBox1 is full and ListBox2 is empty. What I want dto do is when I double click on an item in ListBox1, the item is sent in ListBox2.Antoher way I think to do that was a command button who put the item selected in ListBox1 and put it in...

Hello,I know how to do SQL request. However, I need to do this on a form in access. I have to put the result of my request in a field of a form and I have trouble with that. See the beginning of the code:<b>Dim strSQL As stringstrSQL = &quot;SELECT Sum(FORMCOD.SUPER_COMP)AS SumOfSUPER_COMP FROM...