Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
What is a private synonym?
What is an Oracle index?
What is PL/SQL ?
What are the uses of Database Trigger ?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What the is the diff between local index and global index. give some example.
What is snapshot is too old? Give and example for better understand.
how to do daily transactions with out sql* loader control file regesterd in apps?
1) Does oracle have any table which contain all the exceptions and it's code internally?
what is reindexing?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
how to handle exceptions in post production
How to get maxsal , minsal, ename department wise in single query