Search results for query: *

Is there a method of modifying a date using sqlldr on insert? My data is like the following: 20061002 TESTDATA I would need to change teh 2006 to 2005 on loading. Is there a way to parse the date? Thanks for any ideas!

Is there a more efficient way of setting and getting strings from a bean than like my code below? Seems like way too much code for just setting two strings. Thanks for any ideas. package jspBean; public class dimA { //Indicator 1 String i1; String i2; public void setI1( String value )...

Is there a method to pull all the values from a BEAN and output? My goal is to get a quick count of all the values that equal "0"? Thanks for any advice.

I have the following called from a JSP page: String setI1 = dimA1.getsetI1(); String setI2 = dimA1.getsetI2(); String setI3 = dimA1.getsetI3(); String setI4 = dimA1.getsetI4(); Is there a way I call call these dynically, like in a for loop similiar to this? for ( int i = 1; i < 5; i++) {...

I have a function that returns me a date based on reference data. TABLE_A ------- my_date_fld ref_code select myfunc(my_Date_fld,ref_Code) as NEW_DATE from TABLE_A; Depending on what DATE and REF_CODE I pass to it, a date is returned. I want to get a COUNT(*) of the unique dates returned...

I have a table with exist data: USERS --------- id username lname fname status Every night, I get the same data with updates or new rows added into a stage table. the stage table is refreshed nightly. USER_STAGE ---------- id username lname fname status What would be the best method of...

TABLE_A ------- QUESTION_NO ANSWER TABLE_A ----- QUESTION_NO ANSWER 1 20 2 30 3 50 4 50 5 20 6 20 Is there a way I can group by the QUESTION_No? Like, if I wanted the...