Hi All,
I have a problem when passing string into IF clause:
---------------
IF server = 'FINANCE' THEN
p_temp := '''REQUESTOR'',''ACTING REQUESTOR''';
ELSE
p_temp := '''REQUESTOR''';
END IF...
http://www.experts-exchange.com/Database/Oracle/Q_20562042.html
Zones:
OracleDate Answered: 03/25/2003 Grade: A Views: 0
Hi,
I am having a datafile like this.
T1Col1`T1Col2`T1Col3`T2Col1`T2Col2`T2Col3`T2Col4`T2Col5`T3Col1`T3Col2`T3Col3`T3Col4
```T2Col1`T2Col2`T2Col3`T2Col4`T2Col5`T3Col1`T3Col2`T3Col3`T3Col4
`...
http://www.experts-exchange.com/Database/Oracle/Q_20753458.html
Zones:
OracleDate Answered: 10/19/2003 Grade: A Views: 0
Can anyone tell me why the first query in this set takes about ten times longer than the second:
SELECT first_name, last_name
FROM people
WHERE upper(last_name) LIKE '%ANDERSON%'
SELECT fir...
http://www.experts-exchange.com/Database/Oracle/Q_20763337.html
Zones:
OracleDate Answered: 09/30/2004 Grade: A Views: 0
I have a query that I need to filter data with. I need to say something like (YEAR(DELTEK.PO_LN.ORD_DT)-2, this works fine in the select clause, but it does not work in the having clause or the wh...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21174154.html
I have got an if clause in my coding
like
IF A = 10 or A = 14 or A=20..... then
statement
end if
because I have quiet a lot of this A=.. is there an easy syntax way to...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_21277151.html
Zones:
Visual BasicDate Answered: 01/17/2005 Grade: A Views: 0
Hi,
I have 2 tables which have no foreignkey between them. I have a field in one table t1 which is text. The 2nd table t2 has a long string of text data in a field. I need to show all records wh...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21300962.html
I want to insert/delete to a table in an external database with an expression like:
INSERT INTO targetTable IN tagetPath\targetFile.mdb SELECT * FROM sourceTable
how can I do this if targetF...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21613634.html
Zones:
MS AccessDate Answered: 10/31/2005 Grade: A Views: 0
sql server
folks
I have the following script
select pm.orgid,pm.eqnum,equipment.meterunit1,equipment.avgmeterunit from equipment,pm where PM.EQNUM NOT IN
(SELECT EQUIPMENT.EQNUM FROM EQU...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21693498.html
Zones:
DatabasesDate Answered: 01/22/2006 Grade: A Views: 0
HI,
I have a table that stores postal codes whose data type is varchar.
the postal codes are like
679056578
9775647678
123124324
234525
345435435
Now i want all those postal codes tha...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21700920.html
I have the following query:
SELECT
ed.EmplID,
ed.[Name],
Ext = pd.Phone
FROM
tbldb2EmpDir ed
LEFT JOIN tblPhoneDir pd ON ed.EmplID = pd.EmplID
WHERE
rtrim(ltrim(pd.CFC_PHONE_DESCR...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21811112.html
