When to look for stored procedures, not embedded SQL

Question

I am confused when moving on to stored procedures rather than embedded SQL in code

When I googled, I recognized these points

• They allow modular programming.
• They can reduce network traffic.
• They can be used as a safety mechanism.

Please tell me how network traffic is connected?

Answer 1

they can reduce network traffic only by returning the necessary data to the client.

; /, , , , . , , ,

Answer 2

SP: ( , ), ... , .

: . SProcs , , EXECUTE SProcs - / .

Answer 3

, proc, SQL.

- , SQL - .

Answer 4

, /, SQL, .

, ; SQL, , , .

SQL , . LAMP .

Answer 5

procs ...

, :

• ( db PL/SQL. - )
• ( ).
• / ( / , db )
• ( , - )
• ( -).
• , Fortran , , , .
• // .. ( dbs - )
• .

(, db) , , .

" " . , , .

( , ). - , .

Answer 6

.

• , ?
• ? ?

, , " plsql," SQL "," ". SQL Pl/Sql :

SQL DDL, DML . Oracle. SQL - SQL . - API, Open Database Connectivity (ODBC) Java Database Connectivity (JDBC).

. :

• , Oracle PL/SQL, . , Oracle.

• : Pl/sql

  • • ( , ). db, sql , .. , /. , , , ! sql, .
  • .
  • , SGA.

• pl/sql Oracle, :

  • DML, db

  • sql ** SQL

  • , CURSOR SQL.

  • Complex dynamic sql processing using the dbms_SQL API in combination with native dynamic SQL ( known fourth method ).

  • All modular reasons (you already mentioned): 1 Encapsulating calculations 2 To simplify the subqueries used inside the external sql 3 Combine scalar and aggregate values ​​within the same sql 4 Write once, using a lot.

  • Etc ...