Search results for query: *

I created a pipelined function in Oracle that runs perfect and returns the data just as I need to have it setup to start running calculations in Excel. I use the Microsoft Query tool and it tells me it can't add my table. The SQL is very simple: SELECT * FROM...

We have a manager who setup reoccurring meetings with lots of attendees that is no longer with the company. Is there a way to remove those meetings from everyone's calendars without having to log in as them and delete them one at a time? Appreciate the help. Thank you in advance Cassidy

Basically I am wanting to know how you would take a query that has say 15 rows and turn that into one row comma delimited. The problem I am trying to solve is that I have a work order order that feeds multiple sales orders with different desired want dates. When I prioritize the work order in...

I need to be able to place a filter on a specific table in my 2005 database that when particular users make a request it filters the results so they don't receive information they are not privileged to. Is there a database trigger or stored procedure that I could put in place that would allow...

I have a need that when a user tries to log into an Oracle account, in my case an account named SYSADM, that it validates the OSUSER is one of the approved users to use that account. Is this possible with a logon trigger? Thanks Cassidy

Something changed in my database that I am unaware of. That change now impacts my ability to create and drop users. I can create and drop users just fine as long as I am using the sys account. The second I use my account that has been granted dba permissions I get the following error...

I have no control over the vendor that wrote the application with the bad code or the ability to make it right. The only fix I have is to make sure the problem code is stopped before it does damage. I can not send an error back to the application because it crashes it. I am trying trying to...

I have all my archive logs and would like to create a new database rolled back to a point in time. Is this possible? If so do you have any advice or sites showing how to do that? Thanks Cassidy

Does anyone have an example function that sends an email from Oracle? accepts arguments like to, from, subject, message then sends it. Any help will be appreciated. thanks Cassidy

I need a query that will get me all unique combination of 4 columns. Below is an example of the data: select a1.a, b1.b, c1.c, d1.d from (select rownum as a from part where rownum <= 100) a1, (select rownum as b from part where rownum <= 100) b1, (select rownum as c from part where rownum <=...

I need to modify a trigger in my database. Before data is inserted into the table I need to see if it violates a constraint on the table. If it does then instead of inserting it I need it to update the existing row with the new data. Currently the trigger looks like this: CREATE OR REPLACE...

I need a generic trigger that I can place on any table that will write to an audit table the following: table_name column_name user_id old_value new_value change_date I am picturing a loop to loop through the columns of the table and any column that doesn't match the old value be recorded in...

I have an accounting need that requires a query that will filter accounting results by a date range then add up every combination of accounts in search of a combination that equals a supplied total. I haven't started on my own yet. I have an idea of doing a cartesian join on the journal table...

I have a policy setup on an OU with a test user trying to add zones to local intranet and trusted sites. They show up in the settings page after I modify them but they never apply to the user when they log in. I ran gpresult and it says the policy was applied. It is the only policy on the...

Is there anyway to setup something that sends some type of notification when something changes like triggers disabled, functions/procedures become invalid, etc... Basically anything that happens that causes something in the database to change state. It would be nice to know who did it, what...

I have an ASA 5505 connected to a ASA 5520 over the net via Easy VPN. It has been running great for the last couple of days. However around 2:00p.m. today my ping times went from 60ms to 300 ms across the VPN and I have no explanation why. I am trying to troubleshoot it and figure out how to...

Basically I have two tables: Test Result ----------------------- abcdB 3316 bcdaB 3345 abcd 3316 Test ----------------------- abcd bcda I need a query that will allow me to do a like statement to compare the test from the second table to the test from the first table. If it...

I need to be able to take a distinct column query and turn the data into the columns of a table on the fly. I.E. Column_1 Column_2 -------------------------- red 1 blue 2 green 3 to Red Blue Green -------------------------- 1 2 3 Is there anyone to do...

I have a report that has 4 columns. Each of the columns pertains to the same data but in different ways. Column 1 is this month actual, Column 2 is this month budget, Column 3 is year to date actual, column 4 is year to date budget. Since there is a filter placed on the data I am finding...

I have two lists. I need to compare them and return any rows contain the string, and rank on percentage of string match. Anyone ever do this? Let me know if I need to put an example or if the above is enough. Cassidy