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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DBMS_SQL and cursors
Hi, I'm using DBMS to generate cursors and the output to htp using pl/sql. Basically, I have a table of questions, eg: id, q1a, q2a, q2b, q3, etc and I'm displaying this on the web. It draws it in a table like this: --variable = question name stuff here -- parsing the dbms here -- defining...- benbenben
- Thread
- Replies: 0
- Forum: Oracle: All versions
-
Pleas help with variables and DECODEs
I guess it's going to have to be DBMS_SQL, as I'm using version 8.0.5.1.0 ... Damn!! And I thought I was onto a winner with that one... Thanks anyway ;-)- benbenben
- Post #4
- Forum: Oracle: All versions
-
Pleas help with variables and DECODEs
Thanks Karluk... You have no idea how much that helped :-D !!- benbenben
- Post #3
- Forum: Oracle: All versions
-
Pleas help with variables and DECODEs
Can anyone give any advice on using variable within DECODE? If I use: SUM(DECODE(saq2a, 1, 1, 0)) "1" ...with saq2a being the column name, it works. If I use: v_use := 'saq2a'; SUM(DECODE(v_use, 1, 1, 0)) "1" ...it doesn't work because it gives a comparison error. If...- benbenben
- Thread
- Replies: 3
- Forum: Oracle: All versions
-
Variables within DECODE
Can anyone give any advice on using variable within DECODE? If I use: SUM(DECODE(saq2a, 1, 1, 0)) "1" ...with saq2a being the column name, it works. If I use: v_use := 'saq2a'; SUM(DECODE(v_use, 1, 1, 0)) "1" ...it doesn't work because it gives a comparison error. If...
