Translate

Thursday, July 6, 2017

ROWID and ROWNUM


SELECT ROWID tt, rownum, last_name
   FROM employees
   WHERE department_id = 60;
 
 
SELECT * FROM employees WHERE ROWNUM < 10;


SELECT ROWID ooo, rownum   FROM employees
WHERE department_id = 80

select rowid ooo,rownum, ci.INVENTORY_ITEM_ID  from gmd_recipe_validity_rules ci 

No comments:

Post a Comment

Text Message

WIP TABLES in Oracle Apps R12

  WIP TABLES Oracle Apps WIP KEY Tables   WIP_LINES   WIP_LINES stores production line information. Each row includes a line name, maximum a...