Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ODBC error Table is already in Use
Hi, Inside one of the table there is a column named YTD. (this is under a Adabas DB). WHen I tried to query a query or create view into an 3rd party software I get the error Owner.Table1.YTD is already in use. There is no other process that uses this table or DB while I'm making my test. I... -
Concatenate (in Oracle)
The error I got was Syntax error. I know what I did wrong as an example here's my SQL SELECT customer.job_name || customer.cust_cd, balances.bal_name, sum (cust_ar.balance) FROM customer, balances, cust_ar then my group by would have to be Group By customer.job_name, customer.cust_cd... -
Concatenate (in Oracle)
I tried and it dosen't work. And I made a mistake it's not against an Oracle DB but Informix. I don't if there is big difference between those 2 compare to Oracle Vs SQL since i Oracle we use the || and in the SQL it's more + ('+ ....... thanks Ed -
Concatenate (in Oracle)
Hi All, I'm trying to concatenate one field with another and it's not working. Here's an example of my statement. SELECT customer.job_name || customer.cust_cd, balances.bal_name, sum (cust_ar.balance) FROM customer, balances, cust_ar I'm using the Pipe symbol (||) ans as you can see I have...
