Click here to Skip to main content
15,946,525 members
Home / Discussions / Database
   

Database

 
QuestionDatabase Publishing Wizard alternatives Pin
Todd Smith15-Jul-08 9:15
Todd Smith15-Jul-08 9:15 
AnswerRe: Database Publishing Wizard alternatives Pin
Alsvha15-Jul-08 23:34
Alsvha15-Jul-08 23:34 
Questionautomatica fire event Pin
Member 387988115-Jul-08 4:12
Member 387988115-Jul-08 4:12 
AnswerRe: automatica fire event Pin
Mark J. Miller15-Jul-08 7:07
Mark J. Miller15-Jul-08 7:07 
QuestionHow to make subreport display based on data Pin
imranafsari15-Jul-08 1:25
imranafsari15-Jul-08 1:25 
AnswerRe: How to make subreport display based on data Pin
TheFM23415-Jul-08 5:33
TheFM23415-Jul-08 5:33 
QuestionResetting Identity Column in oracle Pin
meeram39514-Jul-08 23:45
meeram39514-Jul-08 23:45 
AnswerRe: Resetting Identity Column in oracle Pin
scottgp15-Jul-08 3:58
professionalscottgp15-Jul-08 3:58 
The last I knew, Oracle didn't have an identity column. Are you talking about resetting an Oracle Sequence? If so, here's an excerpt from the Oracle documentation:

#

To restart the sequence at a different number, you must drop and re-create it.
#

If you change the INCREMENT BY value before the first invocation of NEXTVAL, some sequence numbers will be skipped. Therefore, if you want to retain the original START WITH value, you must drop the sequence and re-create it with the original START WITH value and the new INCREMENT BY value.
#

Oracle Database performs some validations. For example, a new MAXVALUE cannot be imposed that is less than the current sequence number.
QuestionConfigure SQL 2005 For Remote Connection Pin
swjam14-Jul-08 23:43
swjam14-Jul-08 23:43 
AnswerRe: Configure SQL 2005 For Remote Connection Pin
Tim Leung15-Jul-08 0:30
Tim Leung15-Jul-08 0:30 
Questiondoubt Pin
Kissy1614-Jul-08 23:30
Kissy1614-Jul-08 23:30 
AnswerRe: doubt Pin
Colin Angus Mackay15-Jul-08 3:07
Colin Angus Mackay15-Jul-08 3:07 
GeneralRe: doubt Pin
Alsvha15-Jul-08 23:33
Alsvha15-Jul-08 23:33 
QuestionORA-00936:missing expression Pin
varun_mca_ju14-Jul-08 21:26
varun_mca_ju14-Jul-08 21:26 
AnswerRe: ORA-00936:missing expression Pin
Wendelius15-Jul-08 7:17
mentorWendelius15-Jul-08 7:17 
QuestionQuery Problem in Sql Server 2000 Pin
BalasubramanianK14-Jul-08 19:27
BalasubramanianK14-Jul-08 19:27 
Questionto create pivot table Pin
prithaa14-Jul-08 19:20
prithaa14-Jul-08 19:20 
QuestionRe: to create pivot table Pin
TheFM23415-Jul-08 3:07
TheFM23415-Jul-08 3:07 
QuestionCalculate last week working days [modified] Pin
Member 387988114-Jul-08 18:59
Member 387988114-Jul-08 18:59 
QuestionCalculate last week working days [modified] Pin
Member 387988114-Jul-08 18:59
Member 387988114-Jul-08 18:59 
AnswerRe: Calculate last week working days PinPopular
dan!sh 14-Jul-08 19:01
professional dan!sh 14-Jul-08 19:01 
AnswerRe: Calculate last week working days Pin
tsaunders15-Jul-08 14:19
tsaunders15-Jul-08 14:19 
AnswerRe: Calculate last week working days Pin
tsaunders15-Jul-08 14:34
tsaunders15-Jul-08 14:34 
QuestionSQL Server 2000 Desktop Edition Deployment issue. Pin
rajawaqas14-Jul-08 17:35
rajawaqas14-Jul-08 17:35 
QuestionHow to Grouped Data weekly monthly and Quarterly Pin
Rameez Raja14-Jul-08 16:59
Rameez Raja14-Jul-08 16:59 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.