I have several tables, which have id field as primary key. Most of these id fields are also foreign keys in other tables.
I want to generate unique numeric values for each of these id columns (a...
http://www.experts-exchange.com/Database/Oracle/Q_10230978.html
Zones:
OracleDate Answered: 11/24/1999 Grade: B Views: 0
how can I send an escape sequence to a printer ({esc}r1).
I am using VB4 16 bit and win31.
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10259155.html
Zones:
Visual BasicDate Answered: 01/14/2000 Grade: D Views: 4
When running my application, I get from time to time the following message:
sqlexception-general error or sqlexception-function sequence error.
These errors don't appear all the time(everytime I ...
http://www.experts-exchange.com/Programming/Languages/Java/Q_10292927.html
Zones:
JavaDate Answered: 02/15/2000 Grade: B Views: 0
Dear all,
Inside table A ,there is an integer column entitled "dtfid".Under dtfid,the number sequence is discontinuous,e.g 1,2,3,7,8,10 .How can I write the sql so that I can select the number...
http://www.experts-exchange.com/Database/Oracle/Q_10766061.html
Zones:
OracleDate Answered: 07/24/2000 Grade: A Views: 0
Hope the title makes sense. I am writing a Delphi program that takes care of CGI processing manually (no CGI components). My HTML form contains a TEXTAREA and a few editboxes, but when the user t...
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_11168932.html
The below inserts a row with a unique sequence number, assured only if the table is locked. How does one lock a table in SQL 7, or is there a better way to insure uniqueness, other than using the ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_12003718.html
How can I create a sequence number like x=x+1 directly in select statement in db2.
Sample SELECT x=x+1 || oid FROM tablename.
http://www.experts-exchange.com/Database/Miscellaneous/Q_20173055.html
Zones:
DatabasesDate Answered: 09/18/2002 Grade: B Views: 8
Hi,
I need to update the current data with the new 7 digit sequence number in one table. Here is my sql statement for the sequence and trigger.
CREATE SEQUENCE SYS.SEQ_TARIFF_CODE
INCREMEN...
http://www.experts-exchange.com/Database/Oracle/Q_20189017.html
Zones:
OracleDate Answered: 06/05/2002 Grade: A Views: 0
Is it possible to re-set a sequence without dropping and recreating it? If so please explain in detail.
http://www.experts-exchange.com/Database/Oracle/Q_20285218.html
Zones:
OracleDate Answered: 04/05/2002 Grade: A Views: 0
I want to know that what are step by step previliges that i can assign to database uses : from creating to assigning dba previliges.Note that I am the "system" or having dba previliges.
http://www.experts-exchange.com/Database/Oracle/Q_20455889.html
Zones:
OracleDate Answered: 05/06/2003 Grade: A Views: 0