Hi,
What I know:
If you want to find all records of the table PERSONS where the FIRSTNAME begins with 'Joh' (FIRSTNAME is a VARCHAR2 type column), you do that:
SELECT * FROM PERSONS WHERE FIRSTNAME LIKE 'Joh%';
What I ask:
How do you do that if the column is defined LONG type instead of VARCHAR2? Is it possible to do that?
Thanks
What I know:
If you want to find all records of the table PERSONS where the FIRSTNAME begins with 'Joh' (FIRSTNAME is a VARCHAR2 type column), you do that:
SELECT * FROM PERSONS WHERE FIRSTNAME LIKE 'Joh%';
What I ask:
How do you do that if the column is defined LONG type instead of VARCHAR2? Is it possible to do that?
Thanks