Click here to Skip to main content
15,394,560 members
Home / Discussions / Database
   

Database

 
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 
Questionhow to execute this oracle function ??? Pin
dilipmca0413-Oct-08 23:37
Memberdilipmca0413-Oct-08 23:37 
CREATE OR REPLACE FUNCTION business_date (start_date DATE,
Days2Add NUMBER) RETURN DATE IS
Counter NATURAL := 0;
CurDate DATE := start_date;
DayNum POSITIVE;
SkipCntr NATURAL := 0;
BEGIN
WHILE Counter < Days2Add LOOP
CurDate := CurDate+1;
DayNum := TO_CHAR(CurDate, 'D');

IF DayNum BETWEEN 2 AND 6 THEN
Counter := Counter + 1;
ELSE
SkipCntr := SkipCntr + 1;
END IF;
END LOOP;
RETURN start_date + Counter + SkipCntr;
END business_date;
/
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 
GeneralRe: Archiving a record Pin
Wendelius14-Oct-08 4:54
mveWendelius14-Oct-08 4:54 

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.