Is it stupid to write a complete batch program in PL / SQL?

Question

I am starting work on a program that is perhaps most naturally described as a package of calculations on database tables and will be performed once a month. All input is in the Oracle database tables, and all output will be presented in the Oracle database tables. The program should remain maintainable for years to come.

It seems straightforward to implement this as a series of stored procedures, each of which performs a reasonable transformation, such as sharing costs between departments in accordance with some business rules. Then I can write unit tests to check if the result of each conversion is what I expected.

Is it a bad idea to do all this in PL / SQL? Would you prefer to do heavy group computing in a typical object-oriented programming language such as C #? Isn't it more expressive to use a basic database programming language such as PL / SQL?

Answer 1

Usually I say as little as possible in PL / SQL, as much as possible - it is usually much less maintainable - at one of my last works I really saw how dirty and hard to work with it can work.

, , - PL/SQL - " ". , - - , - , .

Answer 2

a) b)

:

• PL/SQL , . , PL/SQL , . - , .
• .

, , .

, ( / ). OO , , . , , .

.

Answer 3

- - PL/SQL, SQL. , , SQL, PL/SQL. PL/SQL - , . , , , .

Answer 4

, . , , , . OO- ( ) , .

Oracle PL/SQL , , PL/SQL, . , PL/SQL SQL- , , , .

Answer 5

, - , . , - , , " ".

Answer 6

PL/SQL - , SQL. Oracle . , Oracle 11, PL/SQL .

Answer 7

PL/SQL ProC . PL/SQL, , , , ProC.

, Pro * C.

, , script , , script. .

Answer 8

, , PL/SQL, PL/SQL .

- - SQL, , RDBMS , , SQL DML . ..

Answer 9

# SQL.

#:

.NET OO.

#:

* - , .

* sql dang.

SQL:

* . , . .

* sql

* -

SQL:

SQL , SQL.

, SQL - , .

Answer 10

:) , , /. 2 , , , SQL. 3 , " ", SQL , . , "". , 2 1/2- , 2 , .

"-", / , . , , , " ". , , .

, , , , , , SQL- . , , .

, SQL Server. , , . SQL . , , SQL.

, , SQL , , ... SQL, , , SQL/ .

YMMV:)

Answer 11

, . , , , .

, , PL/SQL, , , , PL/SQL .

, , , PL/SQL, "" .

, PL/SQL (, - ) .