I have a table, which I shall call table_name, for that is it's name. Table_name has two columns, column_a, a varchar column; and column_b, a number(10) column.
I have a process which selects information out of column_b, using column_a in the where clause. For some reason, this process keeps lagging: I fire the process, and it never comes back. It locks up my applicaiton/SQL editor in the process.
Having a look at the table, it only has 5 rows, and I can do a successful select count(*) from table_name and select column_a from table_name, but I can't seem to get anything if I include column_b in the select. The longest I've left this process is an hour, but it never comes back.
I doubt it's a table/row lock, because I can get every other sort of data out of this table, except if I include the number column...
update: can't cast the number into a string either. Any manipulations on the column don't return a result.