To: HiTech RedNeck; Lazamataz
PeopleSoft, the #2 or #3 largest ERP install base in the world uses 100% dynamic SQL.
But is is repeatedly CALLED, not REPEATED.
Note: the schema for a typical PS database runs into the 10s of thousands of tables/views. And no DB-level Referential Integrity (which makes sense for their architecture).
82 posted on
08/26/2016 7:54:36 PM PDT by
freedumb2003
(Never Trump=Always hiLIARy)
To: freedumb2003; HiTech RedNeck
PeopleSoft is Oracle, though, and Oracle — from what HitechRedneck tells me — is somewhat more forgiving of Dynamic SQL.
85 posted on
08/26/2016 7:58:34 PM PDT by
Lazamataz
(Every word the "News Media" prints these days are a lie, including "and" and "the".)
To: freedumb2003
And no DB-level Referential IntegrityI simply could not live with that.
Foreign Key Constraints or slit my wrists, baby.
NO ORPHANED RECORDS PLEASE
86 posted on
08/26/2016 8:00:04 PM PDT by
Lazamataz
(Every word the "News Media" prints these days are a lie, including "and" and "the".)
FreeRepublic.com is powered by software copyright 2000-2008 John Robinson