0

I am new to Oracle and SQL. I need to write a select statement for a student extract at a college. For ex:

select ss_id from id_table

This will return all id's from this table and they are a length of 9 digits, i need to return just the last 6 so i can import them as student passwords. Any help would be appreciated. Thanks. Also i am using TOAD, and/or SQL Plus

4
Contributors
4
Replies
5
Views
8 Years
Discussion Span
Last Post by debasisdas
1

Thank you very much, that is exactly what i needed. This was the 3rd forum i tryed in a list from google and you are the first to get it right, and i also appreciate the link.

Votes + Comments
all the best
0

Other method:

select substr(ss_id, -6) from id_table

I am new to Oracle and SQL. I need to write a select statement for a student extract at a college. For ex:

select ss_id from id_table

This will return all id's from this table and they are a length of 9 digits, i need to return just the last 6 so i can import them as student passwords. Any help would be appreciated. Thanks. Also i am using TOAD, and/or SQL Plus

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.