I have a parameter below that could include a Wildcard (@Program).
I can get the code to work below if
= @Program OR
Like @Program
Is there a single line of SQL that works in either conditi...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Studio_.NET_2005/Q_23073...
Two part question:
1) I am trying to write a function that returns a string based upon field values (see code snipit). I think I have that part correct.... What is the statement to 'Returns' ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23087855.html
Good Morning-
I'm trying to join two databases in SQL Developer ( one field in which a trim command is necessary) Please look at the query below and let me know what in my syntax has gone south.....
http://www.experts-exchange.com/Database/Oracle/Q_23427735.html
Hey Guys-
I'm trying to do something... probably super simple and am just missing the boat. I'm trying to select an nth group of records from a simple query. I've tried slect top 5 (but apparent...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23742726.html
I am using Oracle Sql Developer for debugging a simple procedure.
I grant the appropriate privileges:
kims>GRANT DEBUG ANY PROCEDURE, DEBUG CONNECT SESSION TO KIMS;
Grant succeeded.
1. I ...
http://www.experts-exchange.com/Database/Oracle/Product_Info/Q_22472225.html
Hi, I am running a 10g databse on a windows machine. I am able to connect to the db using isqlplus, but not with the sql developer.
connection name: mydb
username: dbtest
password: password
...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23601161.html
Zones:
Oracle 10.xDate Answered: 08/30/2008 Grade: A Views: 83
Hi,
I've downlaoded and installed the Express editions that includes Reporting Services Manager (I think !) But how what are my 1st steps to creating/using reporting services ? I've searched and...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22049419.html
Hi, it seems am unable to install the workstation components MS Sql Server 2005 Developer on Vista Ultimate.
Anytime I try to install them the installation fails.
The server components have be...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2264...
i have a table that is of type varchar2. It has the euro symbol amongs the text ( ¬ ).
when i run the select * from table_name where column_name like '%¬%'; it does not return the full line.
e.g....
http://www.experts-exchange.com/Database/Oracle/Q_23058635.html
Zones:
OracleDate Answered: 01/16/2008 Grade: B Views: 20
I am trying to calculate the average for several fields in a specific time period. We have a table that houses all historic data by month. I have created a Date_BeginState and Date_EndState varia...
http://www.experts-exchange.com/Database/Oracle/Q_23260135.html
Zones:
OracleDate Answered: 03/24/2008 Grade: A Views: 0
