Hi,
I need to substract two dates so i get the difference between them in seconds. When i do something like :
select to_date('14-02-2002 11:30:03', 'DD-MM-YYYY HH:MI:SS') - to_date('14-02-2002 10:30:00', 'DD-MM-YYYY HH:MI:SS') from dual
I get 0,0417013888888889 as a result. Not really 3...
I thank all of you a lot. It helps to hear this information from the experts.
I think i now know enough to write a document with enough of reasons why not to build such a tool.
I hope to learn more about Oracle, so maybe i could be of some help to you in the future also.
Thanks!
Thanks!
I just heared the plan changed a bit. I now have to confince people why we should not create this tool. I need to specify what makes a tool like this practicly impossible to create. I hope you can help me with your Oracle experience with the following :
- I know triggers, constraints...
I investigated some more during the weekend, and found out that i can use select statements within Oracle to find out more about triggers, procedures, constraints etc.
For example :
Select trigger_body from user_triggers ;
Will select all triggers defined within the database.
I can also see...
I just got a little further with my investigation. I found out that it is possible to select stuff from a Oracle database like Select * from user_constraints ( get me the defined constraints ) or select * from user_objects where object type = 'PROCEDURE' ( i think to get all stored procedures )...
Thank you all for the reply's.
I need to build the tool because the owners of the data within the database ( we only manage it for them ) desire to do some minor updates themself, change some values with update SQL, or insert a forgotten record at some point.
They generally know the structure...
Can you tell me why views would have any impact? Why would a view be any different then a query executed directly on a table?
And can stored procedures be triggered directly from a sql command or can they only be activated by triggers? Someone told me about bussines rules, but i'm not sure what...
Thanks for responding,
The problem is that we need to give some departments direct access to the Oracle databases without our DBA's knowing about it. ( maybe not the best way, but it was instructed by the persons that pay my salary ).
The tool must confirm to some requirements. It has to log...
Please help,
I need to write a VB application using ADO to connect to a Oracle server. We will be doing insert, update and select statements on the Oracle database.
The database is allready in production, and i need to know what impact a update / insert statement can have on a oracle database...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.