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 Rating: 7.6 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 Rating: 7.4 Views: 0
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 Rating: 7.2 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 Rating: 6.8 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
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 Rating: 7.0 Views: 0
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 Rating: 9.0 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 Rating: 8.8 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 Rating: 7.8 Views: 0
I am new to oracle and since lots of gurus comes to this place, i am posting this question here. Sorry for the incovenience.
I have table A and Table B
Table A has following fields:
Name
...
http://www.experts-exchange.com/Database/Oracle/Q_20559026.html
Zones:
OracleDate Answered: 03/21/2003 Rating: 7.8 Views: 0