Search code examples
oracle-databaseshellfeedback

Does feedback has default value in oracle, if yes where is it set?

I am running the below query in 2 different DBs

echo "SET HEADING OFF
WHENEVER SQLERROR EXIT FAILURE;
select distinct mkt_cd from $TEMP_MKT_TABLE;
EXIT;" > $DISTINCT_MARKET_SQL
sqlplus -s ${CONNECT_STRING} @$DISTINCT_MARKET_SQL >> text.txt

But in 1 DB i am getting the feedback as "NUMBER OF ROWS SELECTED" and in other DB i am not getting this FEEDBACK. I am not explicitly setting feedback in nay DB. I want to know that Why is it different in the 2 DBs? Can feedback have default value in different DBs? If yes where do we set the default value?

Solution

  • The default value is 6. The default value is set in glogin.sql, in $ORACLE_HOME/sqlplus/admin