Search results for query: *

Thanks HughLerwill, but the del command was just an example. Sorry for the confusion. My goal is actually to establish an sftp connection between my local machine to a remote server (UNIX). I tried to find some libraries for sftp from vb but I can't seem to find any. So my last option is to...

Hi All, Im a writing a simple aps and here I want to execute a command and get the status of the command I spawned. Say, I want to delete a file Shell "del somefile.txt", vbNormalFocus msgbox "Status is OK" The problem here is the Msgbox will appear/executed in parallel with the command I...

Thanks to you all. :)

Hi All, We are working on a DWH environment and every time we need to get the actual number of rows from a table. But the problem is the table has large number of rows and doing a select count (*) from huge_table is taking tooooo long. Is there any way to get the actual or atleast closed to...

Hi all, I would like to know how to write an automated form filler for Internet Explorer -- one that automatically sends text to a textbox. I guess I need to work with the SendMessage function? Please help as I am wasting most of my time working with filling out forms and I guess need to...

Hi tekdudedude, I hope you've already considered of using DESC to show proc/func params within packages. :-)

did you already try to issue the SET SERVEROUTPUT ON command?

The "old ..." "new ..." appears when the VERIFY option is turned on. please include the SET VERIFY OFF before calling the SELECT DECODE ... block. I hope this clears out everything. ;-) Please also try to look every SET options that currently turned on like TIMING, ECHO, etc...

sorry for the duplicate code below the code box. please ignore it.. ;-)

try playing with string manipulation functions: (substr and instr) set serveroutput on size 1000000 declare v_row1 varchar2 (512) := 'Authenticated by: OS; Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.203.31)(PORT=59609))'; v_ip varchar2 (20); begin select substr (v_row1...

start or @ is a sqlplus command which cannot be processed within sql block. as a workaround you can spool your answer into one file. PROMPT Customers PROMPT Orders PROMPT Production PROMPT Quit ACCEPT option PROMPT "option: " spool startthis.sql set head off feed off select decode...

Hi tektipsters! I need a query that would get the minimum possible high water mark for a tablespace for resize. Here's one query I got from the net: select 'alter database datafile ''' || file_name || ''' resize ' || ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) || 'm;' cmd from...

you can also look at user/all/dba_cons_columns