hello guys,
is it possible for me to delete or rename the column name in the table (oracle 8i). if that possible, can anyone give the idea on how to do it.
TQ
Hi,
I'm confused about differences or results in the following 2 queries. One returns the desired results, the other does not The logic that I am trying to accomplish is that I want a lis...
I have a Business Objects *.REP file with multiple queries I need to look at. The problem is I don't have Business Objects. Is there a viewer, or some other method whereby I could view the *...
Does anybody know a way of setting up a batch job to compile Oracle Forms.
My idea is to write a scrpot that allows to 1) compile the latest release version from PVCS VM and 2) copy to produc...
I need to get a PDF print-out of an entity relationship diagram created with ERwin (now published by Computer Associates). The file extension is .er1
I do not own a copy of ERwin, and don't...
Hi,
I need to import a text file (fixed-length) into the table.
I have created a DTS package to automate the process, but now i want to do it programmatically from the web application.
...
This works:
SET @X = Case @Y
WHEN 1 THEN 444
WHEN 2 THEN 555
END
How can I make this work:
Case @Y
WHEN 1 THEN
SET @X = 444
SET @Z ...
I have a problem in a client application which began occurring after an Oracle database installed Oracle 8.1.7. Once the software installation has completed, to configure the Oracle Net8 clie...
Hi,
I have to compare two strings using Oracle SQL to see if they are similar.
For example, the title of a song in one table might be 'White and Nerdy', in another 'WHITE AND NERDY' or 'W...
HI,
At present my SQL Server table has the following field as the Primary Key: mst_rec_nm
I would like a SQL script to re-assign the Primary Key to this field: rtns_prm_key
thanks a lot...
I could't find any explaination about this error message from Oracle8 help file. Normally we will get 5 digits number but this is 6 digits number.. and start with number 3.. emm..
I got thi...
Hello,
Trying to return the rightmost 5 characters in a multi-length field (1-9 characters). In Excel or VB I could use the RIGHT function to get what I want, but I'm using Discoverer which ...
My customer is running SQL svr on Winxp machine. All was working fine until today. For some reason, when he was surfing the internet his computer just shut itself down. He rebooted and ever...
Hi friends
I want to lock the table using the query in oracle so can any body tell how I will do the same I know how to lock the table in SQLServer as
begin transaction
update <tabl...
I have a table structure like this:
idClient DateBuy Price
1 2005/09/01 150
2 2005/08/01 200
3 2005/06/01 300
1 2005/07/01 200
2 2005/06/01 1000
3 2005/05/01 450
I'm trying to do ...
Hi Guys
I am currently traying to connect to DNS, sql databse using ODBC and i need to do this with vbscript. I also need to connect to te database using only NT authentification. I have sear...
Here are the two tables:
The first table is "Customer File"
ID Number First Name Last Name Account Balance
1 JOHN CARTER $0.00
2 CHRIS HARRI...
I need the code in Teradata that I would place in my select statement that would take the first four digits of a column that is formated like this:
2005-02-02
I also will need the code ...
In this instance we are not interested in keeping a copy of the transaction log, but just want to shrink it as effectively as possible.
I have found the following two methods is one prefere...
Could you summarize each Database System's function, requirements, expansion capabilities and how the database is being used and the cost associated with its use. I am an accountant going to ...
Hi
After database is restored, is it nesscary to update statistics on all table and reorg rebuild all table again?
As I have experienced that there is very poor performance after the DB i...
I'm attempting to build a parameter to capture a requested date range from a user for a pass-through query. The date has to be in this format when passed to the SQL: where .....................
I have a stored procedure (listed at bottom in full) that I am trying to add an IF statement to to allow the code to call the stored procedure to either 'select top x' rows or select all rows ...
Hello Experts, I am creating a SQL query in Crystal Reports to run against a Sybase db. My select statement is
SELECT
ad.line1
case
when en.firm is not NULL then en.firm
else e...
Hello, I'm a total SQL beginner, learning fast but needing some help with a report I'm creating.
The report is for a job ledger and the SQL table includes JobNo, Date, CostCode, TotalCost a...
