Inorder to use UNION SET OPERATOR the datatype and the number of columns should match. Here you are trying to get the union of a character datatype and a number, hence you get an error.
Renuka Rajput
Jul 29th, 2006
i would like to add one more point that not only datatypes but also structure of both the select statement should be same.if we write query asselect 1,2 from dualunionselect 1 from dualit will still results in error and the error isexpression must have same datatype as corresponding expression
SQL stands for Structured Query Language. SQL is used for accessing and manipulating databases. SQL can execute queries against a database. SQL can Retrive, insert, update & delete from ...
I have a question... what if the function returns long??i am not able to use in the select query.It says " ORA-00997: illegal use of LONG datatype " .Is there any other way to address this, ...