Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Programming > Java Databases > Re: Derby & Ora...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 2 of 6 Topic 3676 of 3800
Post > Topic >>

Re: Derby & Oracle.

by =?ISO-8859-1?Q?Arne_Vajh=F8j?= <arne@[EMAIL PROTECTED] > Mar 14, 2008 at 06:44 PM

Mr. X. wrote:
> What is the equivalent for Derby, that is in oracle.
> 
> 1. Select 1 from dual.

SELECT 1 FROM SYSIBM.SYSDUMMY1

(yes - the IBM roots can be seen)

> 2. How can I create sequences ?

Derby uses identity columns like SQLServer and MySQL
not sequences like Oracle.

Arne
 




 6 Posts in Topic:
Derby & Oracle.
"Mr. X." <no  2008-03-14 06:14:06 
Re: Derby & Oracle.
=?ISO-8859-1?Q?Arne_Vajh=  2008-03-14 18:44:43 
Re: Derby & Oracle.
"Mr. X." <no  2008-03-16 12:21:26 
Re: Derby & Oracle.
=?ISO-8859-1?Q?Arne_Vajh=  2008-03-16 11:51:04 
Re: Derby & Oracle.
Donkey Hot <spam@[EMAI  2008-03-20 18:52:09 
Re: Derby & Oracle.
=?ISO-8859-1?Q?Arne_Vajh=  2008-03-20 19:41:03 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Jul 25 23:11:25 CDT 2008.