Re: How to do this - SQL

the answer for Q2 is

  select SEQUENCE1.NEXTVAL into myvariable from dual;

Norazman Abu Sahir wrote in message
<01bded98$90809640$c135bcca_at_azhan98.tm.net.my>...
>Greetings newsgroup member,
>
>I have two SQL-ORACLE question,
>
>1)How to write SQL statements that will fetch a certain field
> of the "last record in the table". Say table A which contains
> field named Dept. I realized before this in this newsgroup there is
> a way to get the "last 15" using rownum < 16. However how if I
> don't know how many records in the table but I just want to get
> the last one.
>
>2)The 2'nd question is regarding Oracle Report. Just to clarify
> my understanding. I have a report which have a PL/SQL inside.
> This PL/SQL was written in one of my function.
>
> I can insert a data into my table using sequence. Something like
> this. INSERT INTO TABLE1 (FIELD1,FIELD2)
> VALUES(SEQUENCE1.NEXTVAL, 10);
> It's perfectly OK and insert whatever next value on SEQUENCE1.
> However when I tried to assign the SEQUENCE1.CURRVAL to one of my
> variable it generate an error (outside of the DML operation).
>
> myvariable := SEQUENCE1.CURRVAL;
>
> Because it doesn't recognize SEQUENCE1.
>
> How to assign current value of SEQUENCE1 to my variable.Is it possible?
>
> Appreciate any help. Excuse me for asking siple question. I just another
> newbie...
>
> -NORAZMAN-
>
>
>
>
>
>
Received on Mon Oct 05 1998 - 05:17:05 CEST