bind variables dynamic sql external table views mviews query to sum up pesudo columns virtual coulmns packages and advantages truncate delete exists in merge joins clustered index partitions interval partitioning puring partition loaders schema used in DB design diff between olap oltp scd collections bulk collect ref cursor unique key and primary key if base table is not present can we build the view corelated and subquery how to redirect o/p of the command in shell script