Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #72.9K
2 Posted Topics
Re: Oracle Sql
Other method: select substr(ss_id, -6) from id_table [QUOTE=chevyww1936;802825]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, …
Use this: [code=sql]update t1 a set a.status = 'X' where a.txn_id = (select b.txn_id from t2 b where trunc(b.data) < trunc(sysdate) and b.TXN_ID = a.txn_id)[/code] [QUOTE=ritesh_r10;766495]I have two tables, say t1 and t2. t1{ txn_id varchar status varchar } t2{ txn_id varchar date Date } I want to built an …
The End.