This query will return all tables with and columns that match ‘test’ in any way. If you want to search against
views too, just remove the “t.table_type” restriction:
[Read More]
The following code will execute the method “YourMethod” for the class “Fully.Qualified.TypeName”, and the result of that method will be stored in object “result”.
[Read More]
Sometimes if you are having a performance problem you might want to know what SQL statements are being run - you
can trawl through these to work out what is causing the problem. The v$sql table can be used to view all queries that are being run.
[Read More]
Sometimes you need to pass parameters into your database scripts for variable object names. For example, if your tablespace names are different on live to development, you could do the following for your installation scripts:
[Read More]