Home » RDBMS Server » Server Administration » bind variables
bind variables [message #57353] Sun, 08 June 2003 00:33 Go to next message
Sheila
Messages: 28
Registered: May 1998
Junior Member
Would you please let me know, what the difference is between using literals or bind variables in query parameters?
for example, what has been used in the following SQL statement, a literal or bind variable?
SELECT * FROM table_name WHERE id = 1234;

Report message to a moderator

Re: bind variables [message #57376 is a reply to message #57353] Tue, 10 June 2003 08:54 Go to previous message
SD
Messages: 16
Registered: March 2000
Junior Member
This is a literal. If it was a bind variable, it would look like this

SELECT * FROM table_name WHERE id = :thevar;

Report message to a moderator

Previous Topic: ora-16032 parameter destination string cannot be translated
Next Topic: ORacle 8i.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 08:24:50 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.