Answer Posted / fatima hussain

Oracle 10g is the first database designed for enterprise
grid computing, the most flexible and cost-effective way to
manage information and applications.


Some Sites about 10g:
http://download.oracle.com/docs/html/B14406_01/intro.htm
http://www.cbtplanet.com/study-guide/oracle-db-10g-intro-
sql-ii-study-guide.htm
http://www.learningtree.com/courses/593.htm
http://searchoracle.techtarget.com/sDefinition/0,,sid41_gci1
002023,00.html

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2227