we are not able to start the oracle listner how to start the listner.
can we un install the listener and installed?
if uninstall is done means how to do that one.
and can you tell me how to oracle 11 g for 64 bit windows 7
santhu1
Last Activity: May 12 '14, 11:20 AM
Joined: Jul 6 '13
Location:
-
TNS Listner is not started
-
Hi chaarmann,
thanks for reply i have done some changes it is working fine now.
...Code:StringTokenizer st = new StringTokenizer(due_date, "T"); String str = st.nextToken(); DateFormat fromFormat = new SimpleDateFormat("yyyy-MM-dd"); DateFormat toFormat = new SimpleDateFormat("dd-MMM-yy"); Date date = fromFormat.parse(str); due_date2=toFormat.forma -
convertion of format not working
Hi Friends,
I have one due_date variable as string we are declaring . we get the value from service as "2014-02-17T00:00:00:0" LIKE
but, i want the format like '17-FEB-14' as string why because i need to pass this value as string to another method.
how can i acheive it.
i wrote like this.
...Code:StringTokenizer st = new StringTokenizer(due_date, "T"); String str -
thanks for ur reply rabbit.
i try to check the query once again.Leave a comment:
-
ORA-01427: single-row subquery returns more than one row
...Code:SELECT NB_INWARD.*,(SELECT MODIFIED_ON from nb_application_status_audit where NB_APPLICATION_STATUS_AUDIT.APPLICATION_ID = NB_INWARD.APPLICATION_ID and app_status_audit_code = ( SELECT max(app_status_audit_code) FROM nb_application_status_audit where NB_APPLICATION_STATUS_AUDIT.APPLICATION_ID = NB_INWARD.APPLICATION_ID ) )MODIFIED_ON_FINAL, (SELECT MODIFIED_BY_ID from nb_application_status_audit where NB_APPLICATION_STATUS_AUDIT.APPLICATION_ID
-
thanks rski,
the query is working fineLeave a comment:
-
comments need to add in one row
i have one table. table.
application_id comments
------------------------------
1234123412 pancard
1234123412 driving license
1234123412 birth certificate.
0909090909 adharcard
0909090909 ration card
if i select 1234123412 i want the data like this,
pancard,driving license, birth certificate.
how... -
hi friends,
I got the sloution.
(Code:$F{AMOUNT1}.intValue() >= 5000 ? (" Re.1 " +" Revenue " +" Stamp") : "" )Leave a comment:
-
report error
Hi friends,
I develop one jasper report .
when i am compilng that report it gives error.
error details:
-----------
com.jaspersoft. ireport.designe r.errorhandler. ProblemItem@16f 7d42 The operator >= is undefined for the argument type(s) BigDecimal, int net.sf.jasperre ports.engine.de sign.JRDesignEx pression@105410 0
...Code:( $F{AMOUNT1} >= 5000 ? (" Re.1 " +" -
Hi Luuk,
Finally, I got exact OutPut
Code:TO_CHAR (TO_DATE (TRUNC (PD.AMOUNT), 'J'), 'JSP') || CASE WHEN PD.AMOUNT<>TRUNC(PD.AMOUNT) THEN ' Rupees '|| TO_CHAR (TO_DATE (TO_NUMBER (SUBSTR (PD.AMOUNT , INSTR(PD.AMOUNT, '.') + 1)),'J'),'JSP') || ' Paise' else ' Rupees Only' END
Thanks for ur support.Leave a comment:
-
Hi Luuk,
can u help me in this
Code:SELECT TO_CHAR (TO_DATE (TRUNC (PD.AMOUNT), 'J'), 'JSP') || ' Point ' || TO_CHAR (TO_DATE (TO_NUMBER (SUBSTR (PD.AMOUNT , INSTR (PD.AMOUNT, '.') + 1)),'J'),'JSP') FROM PAYMENT_DETAILS PD ;
when i excute this for decimal values, it gives the result for every value in the amount field. i want the result for only decimal values. if non decimal...Last edited by Rabbit; Jul 7 '13, 05:40 AM. Reason: Please use code tags when posting code. Second warning.Leave a comment:
-
Hi Luuk,
if there is decimals in that PD.AMOUNT how we need to write this.Leave a comment:
-
ORA-01830: date format picture ends before converting entire input string
when i write a query and execute the query it gives error.
My Query
...Code:SELECT NI.POLICY_HOLDER_SALUTATION ||''||PD.DRAWER_NAME AS DRAWER_NAME, PD.ADDRESS_LINE_1 || NVL2(PD.ADDRESS_LINE_1,',','') || PD.ADDRESS_LINE_2 || NVL2(PD.ADDRESS_LINE_2,',','') || PD.ADDRESS_LINE_3 || NVL2(PD.ADDRESS_LINE_3,',','') || PD.CITY || NVL2(PD.CITY,',','') || PD.PINCODE || NVL2(PD.PINCODE,',','') || CHR(10) || PD.STATE AS DRAWER_ADDRESS,
No activity results to display
Leave a comment: