Saturday, 7 September 2013

How can I find unknown number x between specific numbers?

How can I find unknown number x between specific numbers?

Given Values
Min number=2
Max Number=50
increment number=7
x=? needs to be find.
If the correct answer is one of below...How can I find the correct number
that guessed. using given values...
(2,9,16,23,30,37,44)
If this question is hard than, answer below question... :) it is same thing
I would just like to know if it is possible to truncate a sequence to
reset back to its original starting number? in Oracle
Query:
select DBMS_METADATA.GET_DDL('SEQUENCE','SEQ') from dual
Result doesnt give me the original start with value, it only gives the
current value
CREATE SEQUENCE "SEQ" MINVALUE 2 MAXVALUE 50 INCREMENT BY 7 START WITH
9 CACHE 20 NOORDER NOCYCLE

No comments:

Post a Comment