I have a application which extracts certain details and give me a report. Sometime, due to the large number of objects, the select query generated by the expression fails as the number of expression in 'IN' clause exceeds 1000.
This is Oracle specific issue. I could see for the work-around in the net, but I can change anything in the application.
Is there any limit in the Oracle which can be changed, so that it accepts...
praveenmittal
Last Activity: Jan 21 '08, 03:28 PM
Joined: Aug 29 '07
Location:
-
Thanks for the reply.
The Long datatype is working fine. It stores the value has it is and doesnt convert into Exponential form.
With Number datatype, there was no loss of information but the value was getting converted into Exponential form.
I just need to check, any specific datatype like bigint is available in Oracle or not as MSSQL provides (hope so).
Regards
Praveen... -
BIGINT Datatype
I need to create a column which can hold bigint datatype. Sample of the value is 922337203685477 5803.
I tried creating a column using the 'number(20)' datatype, but it stores the value in the following format:
9.2233720368547 8E18.
Please provide the solution.
Thanks
Praveen -
Time function - Oracle
Dear Friends,
I need to know the following:
I will provide a numeric value say 610, and this value has to be converted into respective hours, minutes and second format ie 10 hr 10 min 00 sec.
How can I achieve this. Please provide a query or some guidelines to do it.
Regards
Praveen
No activity results to display
Leave a comment: