ccerdeira

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 …

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 update query which will update t1.status='X' with join condition t1.txn_id = t2.txn_id and t2.date < sysdate. Please let me to build an update query.