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

Item Rate Update for Stock In Trade - Returnable Receive/Return (Loan)

  Stock In Trade - Returnable Receive/Return (Loan)