Welcome! Log In Create A New Profile

Substitution Variables

Posted by ligararu

Announcements		Last Post
	SoC Curricula	09/30/2017 01:08PM
	Demarcation or scoping of examinations and assessment	02/13/2017 07:59AM
	School of Computing Short Learning Programmes	11/24/2014 08:37AM
	Unisa contact information	07/28/2011 01:28PM

Forums Messages New

ligararu

Substitution Variables
June 29, 2010 03:20PM

Registered: 13 years ago
Posts: 7
Rating: 0

Please someone help. What could I be doing wrong. when I run the following query I am getting error message, what am I doing wrong

this is on page 2-24 of the Oracle database 10g manuals

SELECT employee_id, last_name, Salary, department_id
From employees
WHERE employee_id = &employee_num ;

Reply Quote

rezrovs

Re: Substitution Variables
June 29, 2010 04:17PM

Registered: 17 years ago
Posts: 308
Rating: 0

Are you running from the command line or from the web client?

Reply Quote

ExtraLarge

Re: Substitution Variables
June 29, 2010 04:17PM

Registered: 18 years ago
Posts: 2,095
Rating: 0

ligararu Wrote:
-------------------------------------------------------
> Please someone help. What could I be doing wrong.
> when I run the following query I am getting error
> message, what am I doing wrong
>
> this is on page 2-24 of the Oracle database 10g
> manuals
>
> SELECT employee_id, last_name, Salary,
> department_id
> From employees
> WHERE employee_id = &employee_num ;

try removing the "&"...

Reply Quote

rezrovs

Re: Substitution Variables
June 29, 2010 05:02PM

Registered: 17 years ago
Posts: 308
Rating: 0

The & is correct because that is how the system knows to prompt you for the variable. But I could only get this to work from the command line. So I could help you get that right, but unfortunately not from the web client.

Reply Quote

tuxstar

Re: Substitution Variables
June 30, 2010 07:55AM

Registered: 17 years ago
Posts: 8
Rating: 0

I ran into the same problem.

Check Tut letter 102 pg 22. It seems that in the XE environment the ampersand sign & should be replaced with the colon :

Give it a try, it works for some of the code but not for all.

Once again Unisa have not crossed all of the i's and dotted all of the t's angry smiley

Reply Quote

African Boy

Re: Substitution Variables
June 30, 2010 01:28PM

Registered: 17 years ago
Posts: 102
Rating: 0

TRUE.
The "&" should be substituted with a colon " : " if you using the XE environment

Reply Quote

rezrovs

Re: Substitution Variables
June 30, 2010 01:42PM

Registered: 17 years ago
Posts: 308
Rating: 0

Aaaahh!!!! How frustrating that it was that simple tongue sticking out smiley

oh well! Thanks for that smiling smiley