Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by prashjha

  1. prashjha

    What does it mean "SCO" UNIX?

    Santa Cruz Operation
  2. prashjha

    Outer Join -- SQL

    Try : Select Normalised_event_ID, A_Party_Id, B_Party_Id, Full_Path, Name from Normalised_event, tblOperator where Substr(B_Party_Id(+),1,length(code)) = code and trim(full_path) = '107' order by Normalised_event_ID Do let know if it works ....
  3. prashjha

    cursor

    You can use Parameterized Cursor. Make the second cursor parameterized: CURSOR your_cursor(var_emp_id number) is select * from your_table where emp_id = var_emp_id; Then while opening this cursor pass the emp_id from first cursor. Reply if you need more details.
See more

Part and Inventory Search

Back
Top