in Technology by

What is the difference between pre-select and pre-query?

1 Answer

0 votes
by

A pre-query trigger fire before the query executes and fire once while you try to query. With the help of this trigger you can modify the where clause part dynamically.

Pre-select query fires during the execute query and count query processing after Oracle forms construct the select statement to be issued, but before the statement is actually issued.

Pre-query trigger fires before Pre-select trigger.

Related questions

0 votes
    What are some common clauses used with SELECT query in SQL?...
asked Dec 9, 2020 in Technology by JackTerrance
0 votes
    How many records can a select query return? How many records can a SOSL query return?...
asked Nov 11, 2020 in Technology by JackTerrance
0 votes
    I am running following PHP code to interact with a MS Access database. $odbc_con = new COM("ADODB. ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 17, 2022 in Education by JackTerrance
0 votes
    I am running following PHP code to interact with a MS Access database. $odbc_con = new COM("ADODB. ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 17, 2022 in Education by JackTerrance
0 votes
    I am running following PHP code to interact with a MS Access database. $odbc_con = new COM("ADODB. ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 17, 2022 in Education by JackTerrance
0 votes
    The SQL query to create a new database COMPANY * a) SELECT DATABASE COMPANY; b) CREATE DATABASE COMPANY; c) ... All of the above Select the correct answer from above options...
asked Dec 31, 2021 in Education by JackTerrance
0 votes
    An application developer can guard against certain snapshot anomalies by appending a ______ clause to the SQL ... topic in section Concurrency Control of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    I have been working on Power BI for a while now and I often get confused when I browse through help topics of ... two. Please guide me. Select the correct answer from above options...
asked Feb 4, 2022 in Education by JackTerrance
0 votes
    Pre-join projection is equivalent to ________ as in traditional relational systems? Table Materialized view None of the options Joins Stored Procedure...
asked Sep 6, 2021 in Technology by JackTerrance
0 votes
    Before installation of Gulp, installation of _____________ acts as pre-requisite. a) Bower.js b) ... 🔗Source: Continuous Integration Interview Questions and Answers...
asked Dec 20, 2020 in Technology by Editorial Staff
0 votes
    For which reforms were the women’s movement in the pre-independence period fighting? Please answer the above question....
asked Aug 14, 2022 in Education by JackTerrance
0 votes
    strong text [Plugin error at Note entity][1] [1]: Hi,Anyone ... , JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Jul 8, 2022 in Education by JackTerrance
0 votes
    Background: I need to reserve an amount of memory below 0xA0000 prior to my operating system starts. To do ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 17, 2022 in Education by JackTerrance
0 votes
    Background: I need to reserve an amount of memory below 0xA0000 prior to my operating system starts. To do ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 17, 2022 in Education by JackTerrance
0 votes
    My problem is: I have a perl script which uses lot of memory (expected behaviour because of caching). ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 12, 2022 in Education by JackTerrance
...