incerement the values in Oracle insert statement (neagative numbers)

Question

I have to insert data in a table. It has a colum whose values should negative numbers like -1,-2,-3..... so on upto -50. I thought of using sequence but it wont accept the negative values. How can i genarate i mean insert the values??? JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

"I thought of using sequence but it wont accept the negative values." Are you sure? SQL> create table t1 (c1 number) 2 / Table created. SQL> create sequence myseq increment by -1 2 / Sequence created. SQL> insert into t1 values (myseq.nextval) 2 / 1 row created. SQL> r 1* insert into t1 values (myseq.nextval) 1 row created. SQL> r 1* insert into t1 values (myseq.nextval) 1 row created. SQL> select * from t1 2 / C1 ---------- -1 -2 -3 SQL> What version of the database are you using? This is from Oracle 11g R1, but I don't think it's a recent feature.