Breaking News
Home / Sys Admin / Oracle

Oracle

What is Oracle BI Web Services?

Oracle BI Web Services is an application programming interface (API) that implements SOAP. OracleBI Web Services allows you to perform three types of function: Extract results from Oracle BI Presentation Services and deliver them to external applications. Perform Oracle BI Presentation Catalog management functions. Execute Oracle Business Intelligence alerts (known …

Read More »

List all the sequences in a schema?

All the oracle sequences are stored in a table called “dba_sequences”. The following query selects the min, max ,current value along with the length current value and orders it by the length in desc. select SEQUENCE_NAME,MIN_VALUE,MAX_value,LAST_NUMBER,length(LAST_NUMBER) from dba_sequences where SEQUENCE_OWNER=‘schema owner’ order by length(LAST_NUMBER)desc; [pb_builder]

Read More »
Advertisment ad adsense adlogger