Howdy All - I am just wondering if anyone has successfully converted a *massive* (subjectivity implied) COBOL application to another language. If so, into which language was your system converted and when was this done? What were the potholes you, no doubt, hit? Was the conversion far more expensive than anticipated? What hidden costs were exposed? Was there a performance gain/loss in the new language? Did anyone convert from COBOL to PL/SQL? to T-SQL? to Java? to C#.NET? Thanks, and have a great day!

Member Avatar
Member Avatar
+0 forum 10

hi everyone how can I parsing string into token in pl sql? example this is my string "170823-14785" and the parsing I want like this 17 08 23 -1 47 85

Member Avatar
Member Avatar
+0 forum 1

how to order rows in pl/sql? i have a table of numbers, i want to order in ascending order if id of table is odd and descending if id is even

Member Avatar
Member Avatar
+0 forum 5

i want block of code,, that deletes data from different table concurrently,, so that i can save time

Member Avatar
Member Avatar
+0 forum 1

What's the simplest way to read an excel file, get cell 'A1' in table(1,2,3), B3 to table(1,2,3), B6 to Table... import specific cell to table.

Member Avatar
Member Avatar
+0 forum 1

hello. i got a project to do using oracle pl/sql and i want to add a interface (preferably, web) so there aren't just some plain sql scripts. some text boxes, buttons, etc. so it looks nice :D. any suggestions? thank you.

Member Avatar
Member Avatar
+0 forum 2

This is old college assignment am doing to sharpen my sql skills, its cat test centre and this funtion is checking if the mechanic is available on certain date which is input from user in the anonymous block. the problem i m having durning testing is that the function result will only return false and the data inputs are correct [CODE] create or replace FUNCTION MECH_AVAILABLE(mech_id in MECHANIC.MECHANIC_ID%TYPE, todays_date in UNAVAILABILITY.UNAVAILABLE_DATE%TYPE) return boolean is temp UNAVAILABILITY.UNAVAILABLE_DATE%TYPE; begin select unavailable_date into temp from unavailability where mechanic_id = mech_id; if todays_date = temp then RETURN true; else return false; end if; end …

Member Avatar
Member Avatar
+0 forum 4

Greetings, I'm having some trouble creating a trigger that, before I insert something in a table, it resets an existing record field to 0. Example I have in the table a field named "Name" and another named "Active". Each field has a diferent ID The last entry of a "Name" should alaways be the active one, but, I must have several entries that can be active, difering in the name and ID. However, its a bit complex, and I can't think in a solution. Anyone could give me a help to a possible implementation/solution? Thanks in advance...

Member Avatar
Member Avatar
+0 forum 2

I cannot find the mistake in the below code, I receive "statement ignored error" at the last line of the first select clause part of the code:[CODE]SELECT * BULK COLLECT INTO l_employees FROM employees;[/CODE] But I am not sure if thats the real problem. Here is my full code [CODE]declare j number := 0; indx number; begin SELECT * BULK COLLECT INTO l_employees FROM employees; indx := l_empoyees.count; for r in (select * from sde.sdeuser_abone2) loop update sde.sdeuser_abone2 set bina_id = l_employees(indx).ID where objectid = r.objectid; indx := indx - 1; if indx = 0 then indx := l_empoyees.count; end …

Member Avatar
Member Avatar
+0 forum 2

The End.