Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help with 2 Questions ?

Help with 2 Questions ?

From: Jose Luis Perez Garcia <perezjl_at_mx2.redestb.es>
Date: 1998/05/29
Message-ID: <356F0C2D.149B6616@mx2.redestb.es>#1/1

Hi everybody !!

I need help with 2 questions.

First

  1. In a block base table we have to fix the where condition at runtime.

There are two options.

  1. To build the where condition and use set_block_property('block_name',DEFAULT_WHERE,...)
  2. Using the pre-query trigger.

Which is more efficient ?

B Which is the recommended size for a Database Package?. We are using Oracle 7.3.3.

Thank you in advance !!

Kind regards

Jose Luis Perez

PD
Please reply-me also by email if possible !!



 Jose Luis Perez Garcia || jlpg_at_geocities.com
                          || perezjl_at_mx2.redestb.es
 ===================================================
 http://www.geocities.com/SiliconValley/Pines/4148/  http://www.redestb.es/personal/perezjl/
    ____  __    ____   ___   | Enginyer Tecnic
   (_  _)(  )  (  _ \ / __)  |   en informatica
  .-_)(   )(__  )___/( (_-.  |   de Sistemes
  \____) (____)(__)   \___/  |      F.I.B

===================================================
Received on Fri May 29 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US