Click here to Skip to main content
15,389,177 members
Home / Discussions / Database
   

Database

 
AnswerRe: Database Subjects Pin
Kschuler14-Oct-08 8:22
MemberKschuler14-Oct-08 8:22 
AnswerRe: Database Subjects Pin
Mycroft Holmes14-Oct-08 16:44
professionalMycroft Holmes14-Oct-08 16:44 
QuestionSQL Server CE 3.5 AutoIncrement Pin
Searril14-Oct-08 3:17
MemberSearril14-Oct-08 3:17 
AnswerRe: SQL Server CE 3.5 AutoIncrement Pin
Wendelius14-Oct-08 8:20
mveWendelius14-Oct-08 8:20 
GeneralRe: SQL Server CE 3.5 AutoIncrement Pin
Searril15-Oct-08 3:53
MemberSearril15-Oct-08 3:53 
GeneralRe: SQL Server CE 3.5 AutoIncrement Pin
Wendelius15-Oct-08 4:24
mveWendelius15-Oct-08 4:24 
QuestionORA-01722 Error Pin
Rane14-Oct-08 2:04
MemberRane14-Oct-08 2:04 
AnswerRe: ORA-01722 Error Pin
Wendelius14-Oct-08 5:22
mveWendelius14-Oct-08 5:22 
You have several approaches to this, for example:
- use REGEXP_INSTR to find nonnumeric characters. Use this inside DECODE to make the decision if to convert or not
- create a small function which returns number. Inside this, use TO_NUMBER and catch the potential error and ignore it. In case of an error, return NULL (or whatever is desired)

Mika

The need to optimize rises from a bad design.

My articles[^]

Questionhow to execute this oracle function ??? Pin
dilipmca0413-Oct-08 23:37
Memberdilipmca0413-Oct-08 23:37 
AnswerRe: how to execute this oracle function ??? Pin
Wendelius14-Oct-08 5:05
mveWendelius14-Oct-08 5:05 
QuestionDatabase design Questions? Pin
sepel13-Oct-08 23:23
Membersepel13-Oct-08 23:23 
AnswerRe: Database design Questions? Pin
bcozican14-Oct-08 2:09
Memberbcozican14-Oct-08 2:09 
GeneralRe: Database design Questions? Pin
Mark Churchill14-Oct-08 2:42
MemberMark Churchill14-Oct-08 2:42 
QuestionQuery Help Pin
Jaffer Mumtaz13-Oct-08 20:20
MemberJaffer Mumtaz13-Oct-08 20:20 
AnswerRe: Query Help Pin
bcozican14-Oct-08 2:18
Memberbcozican14-Oct-08 2:18 
GeneralRe: Query Help Pin
Jaffer Mumtaz14-Oct-08 18:41
MemberJaffer Mumtaz14-Oct-08 18:41 
QuestionMultiple columns in LIKE Pin
N a v a n e e t h13-Oct-08 15:58
MemberN a v a n e e t h13-Oct-08 15:58 
AnswerRe: Multiple columns in LIKE Pin
Mycroft Holmes13-Oct-08 17:42
professionalMycroft Holmes13-Oct-08 17:42 
GeneralRe: Multiple columns in LIKE Pin
N a v a n e e t h13-Oct-08 19:23
MemberN a v a n e e t h13-Oct-08 19:23 
GeneralRe: Multiple columns in LIKE Pin
Andrew Rissing14-Oct-08 6:43
MemberAndrew Rissing14-Oct-08 6:43 
QuestionLoading column having $ sign to SQL Server... Pin
notes4we13-Oct-08 7:56
Membernotes4we13-Oct-08 7:56 
AnswerRe: Loading column having $ sign to SQL Server... Pin
Wendelius13-Oct-08 9:22
mveWendelius13-Oct-08 9:22 
QuestionArchiving a record Pin
Bolivarian13-Oct-08 7:07
MemberBolivarian13-Oct-08 7:07 
AnswerRe: Archiving a record Pin
Wendelius13-Oct-08 9:25
mveWendelius13-Oct-08 9:25 
GeneralRe: Archiving a record Pin
Bolivarian14-Oct-08 0:12
MemberBolivarian14-Oct-08 0:12 

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.