Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to find a TAB Character in a Table.

568138Mar 21 2007 — edited Mar 21 2007
Data Base : Oracle

I have a table name "EMPLOYEE" which has 2 columns
employee_Name and employee_number.

I have all the data available in Textpad. This textpad contains all the employee name and employee number information.

We are manually copying the data from the textpad and pasting into the table through TOAD.

since we are manually copying the data from the textpad and pasting into table, there are some TAB ('\t') characters that is present in the textpad that copied into the table employee.employee_name column.

I want to find out the list of records that has the TAB Characters in the employee.employee_name column.

please let me know, what SQL query i have use to find out the invalid records.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 18 2007
Added on Mar 21 2007
1 comment
9,024 views