Database Administration (MOSC)

MOSC Banner

ONE PROCEDURE VS 1000 PROCEDURES

edited Aug 10, 2016 5:00AM in Database Administration (MOSC) 4 commentsAnswered

ONE PROCEDURE VS 1000 PROCEDURES.

I have 10000 of users in a analytics application . Each using 1000 of different select sql.

My question is what's the best way to write this . Keeping in mind everyone is using bind values:-

1) Write 1000 distinct bunch of sql in a application .

2) Write 1000 different procedures in 1000 distinct sql.

3) Write 1000 different procedures in a sql.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center