I want to create a procedure that will return a sequence number. I want to be able to pass the sequence name and have nextval increment the sequence and return it. I tried the below procedure, bu...
http://www.experts-exchange.com/Database/Oracle/Q_20109714.html
Zones:
OracleDate Answered: 05/14/2001 Grade: A Views: 0
Dear Friends.
Is there a way to rollback CURRENT VALUE (currval) of a SEQUENCE (that I have generated using SEQUENCE.NEXTVAL option).
Thanks
Hiranya
http://www.experts-exchange.com/Database/Oracle/Q_21239952.html
Zones:
OracleDate Answered: 12/13/2004 Grade: B Views: 32
Hi,
I am trying to populate a table from the result of joining records from different tables and adding a unique record indicator. I have used the following statement:
INSERT INTO EXIST_EQUI...
http://www.experts-exchange.com/Database/Oracle/Q_21343584.html
Zones:
OracleDate Answered: 03/09/2005 Grade: A Views: 38
I am attempting to insert into a table using NEXTVAL. Here is my code and I am getting an error that the sequence doesn't exist, but I thought this was an Oracle standard that would work. Anyway:...
http://www.experts-exchange.com/Database/Oracle/Product_Info/Q_21616547.html
Hi,
I'm writing stored procedure that should insert a row into table and return it's ID. If function fails it should return -1.
FUNCTION add_cell_names(
vcCellName IN CELL_NAMES.CELL_NA...
http://www.experts-exchange.com/Database/Oracle/Q_10261275.html
Zones:
OracleDate Answered: 01/18/2000 Grade: A Views: 0
I am trying to load master/detail type records with sqlldr. I am using when clauses to decipher which table to load into. The setup looks like
Master
--detail_table1
--detail_table1
--detail...
http://www.experts-exchange.com/Database/Oracle/Q_20189249.html
Zones:
OracleDate Answered: 06/06/2002 Grade: A Views: 5
In my database some tables have KEY columns that get populated using triggers/ seq numbers.
Very frequently we encounter this issue that Max(key) value is greater than NEXTVAL of sequenc...
http://www.experts-exchange.com/Database/Oracle/Q_20924883.html
Zones:
OracleDate Answered: 03/23/2004 Grade: B Views: 24
Hi I seem to be having some error messages as follows:
Warning: reset(): Passed variable is not an array or object in /home/www/cahyndic/readtemplate.inc on line 49
Warning: Invalid argument su...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/Q_21110543.htm...
Zones:
PHPDate Answered: 09/12/2004 Grade: B Views: 0
Hi,
I used nextval and currval in my asp page. Basically, I want to perform the below:
1. Get the nextval in the sequence (seq_xmlfile) and use it as part of a filename.
2. Store the currva...
http://www.experts-exchange.com/Database/Oracle/Q_21487978.html
Zones:
OracleDate Answered: 07/13/2005 Grade: B Views: 197
I am creating a new instance of an application using a schema from a previous instance. So I just finished doing a lot of cleaning out of tables, and removed all but three items from a certain tab...
http://www.experts-exchange.com/Database/Oracle/Q_21564179.html
Zones:
OracleDate Answered: 09/16/2005 Grade: A Views: 0
