3 Replies Latest reply on Jun 29, 2015 2:36 PM by Ramesh Reddy

    select query without "where" clause gives error -Invalid column types.

    Prashanthi Kairuppala Novice

      Hello,

       

      We have created a VDB by importing Oracle database, and tried to Execute the VDB.

      query -> {select * from <TableName> where "cloumnName" = 1234}  is giving correct output, but just {select *from <TableName>} is giving error "Invalid column type".

      Any reason for this behaviour? Is it because of any restrictions on database or large amount of data being fetched?

       

      Thanks in advance.

      Prashanthi.