Four ways to make your PL/SQL quicker to write, run, and manage

If a programmer writes PL/SQL the way developers did with earlier versions of Oracle, their code may potentially wind up costing their organization time, resources, and money. Fortunately, by adopting best practices for programming PL/SQL in a newer style, they can write code that runs faster and is...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Veröffentlicht in:Exploring Oracle Jg. 10; H. 12; S. 1
1. Verfasser: Katz, Chaim
Format: Trade Publication Article
Sprache:Englisch
Veröffentlicht: Louisville Element K Journals 01.12.2005
Schlagworte:
Best practice
Data base management systems
Guidelines
Software engineering
Structured Query Language-SQL
United States
US
ISSN:1098-4755, 1539-0292
Online-Zugang:Volltext
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Abstract If a programmer writes PL/SQL the way developers did with earlier versions of Oracle, their code may potentially wind up costing their organization time, resources, and money. Fortunately, by adopting best practices for programming PL/SQL in a newer style, they can write code that runs faster and is easier to make changes later on. These best practices are detailed.
AbstractList If a programmer writes PL/SQL the way developers did with earlier versions of Oracle, their code may potentially wind up costing their organization time, resources, and money. Fortunately, by adopting best practices for programming PL/SQL in a newer style, they can write code that runs faster and is easier to make changes later on. These best practices are detailed.
Author Katz, Chaim
Author_xml – sequence: 1
  givenname: Chaim
  surname: Katz
  fullname: Katz, Chaim
BookMark eNqNir0OgjAYRRuDiaC-Q90htgUEJgcjcWDA6E4a_TSIttCfEN5eSHwAp3Nz7vGQI6SAGXJpHGYBYRlzxk2yNIiSOF4gT-sXISykNHHRPpdW4Z4PGhuJP7wBPEymLLaXc4E7W98aUNPXq9qAj5UVPubiPraCP2GF5g_-1rD-cYk2-fF6OAWtkp0FbSoFrVRGV4ykUUIp2YX_NF-iHzj0
ContentType Trade Publication Article
Copyright Copyright Element K Journals Dec 2005
Copyright_xml – notice: Copyright Element K Journals Dec 2005
DBID 3V.
7XB
8AL
8FE
8FG
8FK
ABUWG
AFKRA
ARAPS
AZQEC
BENPR
BGLVJ
CCPQU
DWQXO
GNUQQ
HCIFZ
JQ2
K7-
M0N
P5Z
P62
PHGZM
PHGZT
PKEHL
PQEST
PQGLB
PQQKQ
PQUKI
Q9U
DatabaseName ProQuest Central (Corporate)
ProQuest Central (purchase pre-March 2016)
Computing Database (Alumni Edition)
ProQuest SciTech Collection
ProQuest Technology Collection
ProQuest Central (Alumni) (purchase pre-March 2016)
ProQuest Central (Alumni)
ProQuest Central UK/Ireland
Advanced Technologies & Computer Science Collection
ProQuest Central Essentials
ProQuest Central
Technology collection
ProQuest One
ProQuest Central Korea
ProQuest Central Student
SciTech Premium Collection
ProQuest Computer Science Collection
Computer Science Database
Computing Database
Advanced Technologies & Aerospace Database
ProQuest Advanced Technologies & Aerospace Collection
ProQuest Databases
ProQuest One Academic (New)
ProQuest One Academic Middle East (New)
ProQuest One Academic Eastern Edition (DO NOT USE)
ProQuest One Applied & Life Sciences
ProQuest One Academic (retired)
ProQuest One Academic UKI Edition
ProQuest Central Basic
DatabaseTitle Computer Science Database
ProQuest Central Student
Technology Collection
ProQuest One Academic Middle East (New)
ProQuest Advanced Technologies & Aerospace Collection
ProQuest Central Essentials
ProQuest Computer Science Collection
ProQuest Central (Alumni Edition)
SciTech Premium Collection
ProQuest One Community College
ProQuest Central
ProQuest One Applied & Life Sciences
ProQuest Central Korea
ProQuest Central (New)
Advanced Technologies & Aerospace Collection
ProQuest Computing
ProQuest Central Basic
ProQuest Computing (Alumni Edition)
ProQuest One Academic Eastern Edition
ProQuest Technology Collection
ProQuest SciTech Collection
Advanced Technologies & Aerospace Database
ProQuest One Academic UKI Edition
ProQuest One Academic
ProQuest Central (Alumni)
ProQuest One Academic (New)
DatabaseTitleList Computer Science Database
Database_xml – sequence: 1
  dbid: BENPR
  name: ProQuest Central
  url: https://www.proquest.com/central
  sourceTypes: Aggregation Database
DeliveryMethod fulltext_linktorsrc
Discipline Computer Science
EISSN 1539-0292
ExternalDocumentID 938391421
Genre Instructional Material/Guideline
GeographicLocations United States
US
GeographicLocations_xml – name: US
– name: United States
GroupedDBID 29G
3V.
5GY
7XB
8AL
8FE
8FG
8FK
8FW
8R4
8R5
ABUWG
AFFHD
AFKRA
AGGLG
ALMA_UNASSIGNED_HOLDINGS
ARAPS
AZQEC
BENPR
BGLVJ
BPHCQ
CCPQU
DWQXO
GNUQQ
HCIFZ
JQ2
K6V
K7-
M0N
P62
PHGZM
PHGZT
PKEHL
PQEST
PQGLB
PQQKQ
PQUKI
PROAC
Q2X
Q9U
ID FETCH-proquest_reports_2084711063
IEDL.DBID K7-
ISSN 1098-4755
IngestDate Tue Dec 23 17:40:13 EST 2025
IsPeerReviewed false
IsScholarly false
Issue 12
Language English
LinkModel DirectLink
MergedId FETCHMERGED-proquest_reports_2084711063
PQID 208471106
PQPubID 34280
ParticipantIDs proquest_reports_208471106
PublicationCentury 2000
PublicationDate 20051201
PublicationDateYYYYMMDD 2005-12-01
PublicationDate_xml – month: 12
  year: 2005
  text: 20051201
  day: 01
PublicationDecade 2000
PublicationPlace Louisville
PublicationPlace_xml – name: Louisville
PublicationTitle Exploring Oracle
PublicationYear 2005
Publisher Element K Journals
Publisher_xml – name: Element K Journals
SSID ssj0023117
Score 2.6017513
Snippet If a programmer writes PL/SQL the way developers did with earlier versions of Oracle, their code may potentially wind up costing their organization time,...
SourceID proquest
SourceType Aggregation Database
StartPage 1
SubjectTerms Best practice
Data base management systems
Guidelines
Software engineering
Structured Query Language-SQL
Title Four ways to make your PL/SQL quicker to write, run, and manage
URI https://www.proquest.com/docview/208471106
Volume 10
hasFullText 1
inHoldings 1
isFullTextHit
isPrint
link http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwY2BQSbM0MTNMBE27J5um6YLOH9FNAvZ3dA3SDIGNiTSzJCOzJPBlE-Z-fhYREZYB0LU5xdBllbAyEVxQp-Qng8bIgZ10UDkK7MDYFxTqgi6NAk2uQm_QYGZgNQTtHgLNyZrrwvtbxobgC3cNQUdmmpibmmIUt-A6xE2AQtsFGSSB9UpKqgLSQJuCIyTehRiYUvOEGQRgVzQoQHOsCIO9GzCtKJQnVhYrlOQr5CZmpypUgkQCfPSDA30UCkszQcsqQHLlRUC7dBSKSvN0FBLzUhQgy1pFGRTdXEOcPXRh7o2HTjLEw91qLMbAkpeflyrBoJBkapmYYm5mYp6aYmySlJQMOgUO2HSyNEkD5mdgG0GSQQq3OVL4JKUZuCCnmYJWeMgwsJQUlabKMrAll5VkFhfJMbA6ufoFBMmBIwZIBphGAQB645yS
linkProvider ProQuest
linkToHtml http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwxV1LS8NAEB5qKuipPmnrawS9NWjaPMxBio-WlsZQtYfeSh4bKGJqk9aSf-9M0hRBVDx53V2GYXf4dmZ2dj6As8BUdcXhZ3dPC2TuPyK7FO_Il4FCzkSgu3XdTckmDNu-Gg7NfgGS_C8Ml1XmmJgCtT_xOEdOQTrjKAUwzbepzKRR_LiaM2hkVtETyYIitvi6e0_He16vt1uDu46cixsts_CjlagGrVmDIn-uVCUo3rbs_tMqWmsoKV2vwg03VUPTvoB1egO1S_-o-xZU6EbzBX5K8eFNZnHbUBDhDpRycghcYsUuNNtkpbhwkhhnE3x1XgQmPNK3Lp4fLZzOx1zQwXOLiPSsYTQPa-iEPmYFtXtw-qty-yCFk1CUAV3NdHxDVw3hN1TX9bj_HDltphoQkpB3UoHq93KqP02ewEZn8GCNrK7dO4DNrKcq15kcgjSL5uII1r332TiOjpdHi1D7y-5-AFJR0vc
openUrl ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=article&rft.atitle=Four+ways+to+make+your+PL%2FSQL+quicker+to+write%2C+run%2C+and+manage&rft.jtitle=Exploring+Oracle&rft.au=Katz%2C+Chaim&rft.date=2005-12-01&rft.pub=Element+K+Journals&rft.issn=1098-4755&rft.eissn=1539-0292&rft.volume=10&rft.issue=12&rft.spage=1&rft.externalDocID=938391421
thumbnail_l http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/lc.gif&issn=1098-4755&client=summon
thumbnail_m http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/mc.gif&issn=1098-4755&client=summon
thumbnail_s http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/sc.gif&issn=1098-4755&client=summon