Search results for query: *

Is it possible to search in SQL Developer for where a view or packages is used? An example, view is view_a, I want to know all objects where view_a is mentioned. is this possible in SQL Developer search function? How?

I installed the Oracle Express 10g. When I click to "Go To Database Home Page", I get an error. Using Windowx XP w/ SP3 and IE 8. Error is standard IE8 error, "Diagnose Connections Problems" I'm able to ping 127.0.0.1. What steps should I do to resolve this issue?

Using MS Office 2003. I created a workbook that contains 3 sheet. Sheet 1 retrieves data from sheet 2 and 3. Sheet 2 import data from an external csv file in the same directory as the workbook. When the workbook is open, the Query Refresh dialog box is displayed. When the "Enable...

I have a Console Application written is VB.Net 2005. I need to moved it to a server for QA testing. Should I publish it using the Publish Wizard or copy the .exe? If I publish it, after install is executed on the server, what do I execute in a scheduled task? Is it the .application member?

I have 2 VB.NET Console Applications that executed at different times from a web server. In most cases, the web server will not be logon. One of the console Applications executes daily at 5:30 am and the other every 25 minutes. It has been suggested to code a Windows Service to start these...

I have a VB.Net (VS2005) Console Application. It is reference a csv file on a different server. At the end of the program it is require to copy the csv file to another directory on the other server and append the date to it for archive purpose. It then deletes the csv file. It is receiving...

I have a VB.Net Console Application, it uses SQL Server. I have 4 SQL server/VB environments (DEv, QA, TrNg, Prod). I want to retrieve the SQL Server name from a session variable is available. How do I do this? The other alternative is to pass it in, but don't know how to do this when the...

I have a structure that contains variables (i.e. Name, Address, Cit, State, Zip, telephone). Is there a way to clear the structure with 1 command, like structure.clear? or must I clear each variable?

I'm new to VS 2005 using VB.Net. I found a free ware documenter program (GhostDoc) for VB. In using and viewing the results. I found that I have methods included from web references that I included into my project. Is there a way to exclude the methods used be references and web references...

This is a newbie question. Is this possible? I want to group variables into something I'm able to pass to Sub modules. One module will load the variables the others will read and process based on the variables. I built a Structure. but after the load module ended the contents of the...

I have research the app config file for VB.Net. I understand how to code the parameters. What I didn't see is how it works when the program is moved between environment. The coding environment is VS 2005 with SQL Server 2005. There is a Dev, QA, and Production environment. My questions...

I'm coding my first VB.Net program. The process is to read a .csv file and write the records to a SQL Server 2005 table. I'm getting an error when a column is empty. I need to put a NULL in the column. In the code below; Currentline(10) is either empty or has a value. If the value is...

I'm trying to write query that will select rows from 1 table and using that select rows from another table. The catch is that the other table may not have a matching row. An example Select client, site, product, family from tab_a where product = 'a' on the other table (tab-b) are the values...

Is it possible to code an db2 select in the Microsoft Query function of Excel with the AS clause? Example Select last_name || ',' || first_name AS Name, address from address where last_name = 'Jones' Does the 'AS Name' work in Excel?

What is the best way to code for selecting the row that have last names between 'a' and 'm'? There are multiple columns in the query. It will be used in a spreadsheet and currently returns on the row limit of 65536 rows. I want to break it into selecting a through m and n through z. I...

I'm not sure if this is able to be coded. Using DB2 v8 on IBM Z/OS executing in v7 mode. I have 19 unique products that a customer may place a call for. I need to count the number of calls for each product by customer. Is this possible? Here is a example Customer 1 ABC Corp has 5 calls...

I have a spreadsheet that has 1530 rows. I need to separate it into other spreadsheet based on a cell content (centers). An example: is that a spreadsheet would have centers; 5, 55, 101, 200. There are other spreadsheets with the remaining centers.

I attempting to use the SQL Server 2005 encryption function. The code is in a ASP page with no display to the screen. The definition of the cc_number_encrypt column is varbinary(256). The update works in SQL Server Management Studio Query, but not in the program. It leaves the columna as NULL...

Using SQL Server 2005 Symmetric key to encrypt the credit cardnumber. All setup steps have been completed. I have tested using SQL query and verified that the encryption works. In the program (VBScript); I coded this statement; rsOrderHeader("cc_number_encrypt") =...

I need to add encryption to a column in an SQL Server 2005 table. The Symmetric key and certificate have been created. I have verified that in Management Studio that I'm able to insert into the encrypted column. When I coded the Open symmetric into the program source, I get an error. It is...