[pl-sql] Forum Topics

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 …

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

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

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

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.

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.

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 …

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" …

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 …