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 )...
Dian,
Currently, my code is like this. If I remove the following:
public String getsetI1() { return i1; }
How do I get my specific value returned?
---CODE------- (not sure how to mark this as code from teh forum)
package jspBean;
public class dimA {
//Indicator 1
String i1;
String i2...
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...
In this case, data would not be deleted. The status field would be updated to reflect invalid data. I would still have teh original data, but information could change, like a last name (someone gets married) or as I mentioned, the status would change to make that row invalid.
thanks!
JE
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.