Viewing 15 posts - 2,326 through 2,340 (of 26,488 total)
November 30, 2017 at 10:30 am
BEGIN
IF NOT EXISTS(SELECT * FROM sys.indexes WHERE object_id =...
November 30, 2017 at 10:28 am
Here is an idea, drop the WHERE clause and visually inspect the name column.
November 30, 2017 at 10:12 am
myukas - Thursday, November 30, 2017 9:53 AMno FACTS will just be in the trigger name
Yes, the query will find all trigger...
November 30, 2017 at 9:54 am
My first query.
November 30, 2017 at 9:50 am
Or perhaps this if you are looking for FACTS in the trigger definition.
SELECT *
FROM
[sys].[sql_modules] AS [sm]
INNER JOIN [sys].[triggers] AS [t]
...
November 30, 2017 at 9:47 am
Tried this?
SELECT * FROM sys.[triggers] AS [t]
WHERE [t].[name] LIKE '$FACTS%';
November 30, 2017 at 9:42 am
November 30, 2017 at 8:03 am
Okay, you seriously need to figure out what it is they are expecting and figure out a better way to get it. You are scanning the same index several times with...
November 29, 2017 at 2:23 pm
The query may run long, but if you could post the actual execution plan as a .sqlplan file that would provide us with additional information.
November 29, 2017 at 11:06 am
My suggestion, get your company to pay for TOAD, it is awesome for working with Oracle.
November 29, 2017 at 10:59 am
This coming weekend is going to be interesting to say the least. So many different ways things can go.
November 28, 2017 at 4:29 pm
November 28, 2017 at 11:07 am
Viewing 15 posts - 2,326 through 2,340 (of 26,488 total)