Home/ s3di/Followers Questions

Oraask Latest Questions

Question
Chandra
  • 1
ChandraExplorer
Asked: October 31, 2017In:
  • 1

hello guys, please help me to get the po change history for revision details when we compare current po with original po? thanks in advance.

ebs archivingfricew componentsgetpooracle ebs historyoracle ebs version historyoracle riceoracle rice componentsoracle ricewpo archive tables oracle appspo change historypo change history query in oracle appspo change history table in oracle appspo historypo history table in oracle appspo revisionpo revision table in oracle appspo_distributions_archive_allpo_headers_archive_allpo_line_locations_archive_allpo_lines_archive_allqueryrice componentricewricew oraclesqlsupply chainwhat is ricew
Question
Waqas
  • 0
WaqasExplorer
Asked: August 12, 2017In:
  • 0

Hi, Oracle : 9.2.0.8.0 We have sequence as below: [code] CREATE SEQUENCE TEST_SEQ START WITH 41554558016 INCREMENT BY 2 MAXVALUE 1000000000000000000000000000 MINVALUE 1 NOCYCLE CACHE 40 NOORDER; [/code] We have written a procedure to increment the sequence value based on another sequence value by comparing the two values. But when I execute the procedure ...

execute immediateincrementingproceduresequencesql