Search results for query: *

I am new to VB and I have a simple requirement - I have a directory which has 3 excel sheets and I need to combine them programatically into one workbook so that each sheet is on different tabs(wksheets) within that. I want to do this via Access/Vb when user pushes a button. Directory...

I have a requirement to get the IP's stored in a table in a standard format. The IP's are as below. I'm just taking into consideration the first Octant currently. 010. 011. 167. 001. 065. 170. I need to change these in the format below and remove the zero padding.As there are millions of such...

A very basic question about SQL , about Temporary Substitution Variable that is '&' Ampersand Whenever I use '&' to accept input from user before running a sql statement, I get a standard prompt. See Eg. below. SQL> Select * from Emp where empno = '&eno' ; 'Enter value for eno:' Is...

I need to query Oracle database while I am in Access. I am able to programatically create a passthrough query and change its definition as required. My problem is that my query gives ODBC error and can't connect first time. However, if I manually do a sample passthrough query and then come...

I am trying to run a query select id, subid, brand from xyz where code = 'A' and (id,subid ) NOT IN (select substr(z_id,1,3) , substr(z_id,4,3) from ABC where model = 'P') My problem here is that the "NOT IN" does not work as expected and returns all rows which meet the condition...

I am running a Batch file (.bat) from Windows 2000. This Batch file invokes sqlplus and calls a sql script.Once the script is executed, I get a dmp file in the specific location in C Drive as coded. However, when I execute the batch file which invokes a sqlplus -s session, I get two windows 1...

I take 4 pair of inputs from user in a SQL query with '&Variable'. The input is part of DECODE statement(in the Where -Clause) and it pulls the data from the Table as per the DECODE condition. However, my result set is not in the order of the user-input. I want to sort it as per the data user...