Click here to Skip to main content
15,395,360 members
Home / Discussions / Database
   

Database

 
AnswerRe: Database Subjects Pin
Paul Conrad14-Oct-08 7:17
professionalPaul Conrad14-Oct-08 7:17 
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 
select m_id from w_mat where ( w_mat.row_id in (Select prime_id from d_table where a_type=3 and o_type='XXX' and a_name='YYYY' and ( decode(REPLACE (TRANSLATE(TRIM(a_value),'-.0123456789', '000000000000'), '0', NULL), NULL,to_number(TRIM(a_value))) = 1 )) ) order by 1


If a_value encounters a non-numeric value, this query returns an error. Is there a way to modify the query to look for the particular value (i.e) 1 and ignore if it encounters any non-numeric value during the data fetch..


Regards,
Rane
AnswerRe: ORA-01722 Error Pin
Wendelius14-Oct-08 5:22
mveWendelius14-Oct-08 5:22 
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 

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.