Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Defining Validations IN Oracle Tables, Programmatic Way of Implementing Validations
sumak
post Sep 20 2017, 11:37 AM
Post #1


Newbie
*

Group: Members
Posts: 8
Joined: 22-June 17
Member No.: 52,035



Hi Burleson,

I need your expert advice in implementing validation as rules residing in Oracle Tables.

We have a requirement from business, where in all the validations that needs to take place while loading data into the system should be configured inside database.

For example ,, data is uploaded using an excel template. Once the data is temporarily loaded into a table ,, we are thinking to use different functions to validate the data.

Although this will hit performance in case of high volumes, we dont see any other solution.

Could you please suggest any other way of achieving this?


Regards,
Sudha.
Go to the top of the page
 
+Quote Post
burleson
post Sep 20 2017, 02:24 PM
Post #2


Advanced Member
***

Group: Members
Posts: 13,577
Joined: 26-January 04
Member No.: 13



Hi Sudha,

In pl/sql, all of the code is stored in the database.



--------------------
Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 23rd October 2017 - 03:44 PM