Within SQL context:
select sequence_name.NEXTVAL
from dual;
In PL/SQL Context:
select sequence_name.NEXTVAL
into v_variable_name
from dual;
--Payam Moghtader
www.2dev.com
-----Original Message-----
From: Martin Farber
[mailto:oracledba-ezmlmshield-x17296915.[Email address protected]
Sent: Friday, August 31, 2007 2:27 AM
To: LazyDBA Discussion
Subject: Re: importing data from exported file sequence values
How are you assigning the sequence - a trigger?
<<MrO>>
----- Original Message -----
From: "Rajavardhan "
<oracledba-ezmlmshield-x62439058.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Friday, August 31, 2007 12:18 AM
Subject: importing data from exported file sequence values
>
>
>
>
> Hi
>
>
>
> Dba gurus
>
>
>
> I have imported tables from exported file when I imported
>
> From exported file
>
> there are sequences used In the database
>
> when import the data the sequences' it is incrementing from current
values
>
>
>
> example
>
>
>
> when I created the sequence minvalue is 1
>
>
>
> then I have inserted 20 records my currentval is 20
>
>
>
> next I exported and imported into another system
>
>
>
> now the value is 21 ,20,.....40
>
>
>
> how can stop increment like this
>
>
>
> I want sequence ids 1,2,3,4,....20 instead of 20,21,22,23
>
>
>
> Plz help me
>
>
>
>
>
>
>
>
>
> Thanks & Regards
>
>
>
> V.Rajavardhan Reddy
>
> Database Administator
>
> GSS America Infotech Ltd.
>
> Block B, 3'rd Floor,
>
> Cyber Gateway,
>
> Hi-Tech City,
>
> Hyderabad.
>
> Tel:- 040-40028700
>
> Fax:- 040-40028703
>
> Visit us: http://www.gssamerica.com
>
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post
> a dba job: http://jobs.lazydba.com To Subscribe :
> http://www.LazyDBA.com To unsubscribe:
> http://www.lazydba.com/unsubscribe.html
>
>
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page