How can you prevent the users logging in through tools like TOAD or SQL Navigator or PLSQL Developer..?
Connect as sydba Write a LOGON trigger like this CREATE OR REPLACE TRIGGER RESTRICT_TOOL AFTER LOGON ON DATABASEDECLARE L_TOOL V$SESSION.PROGRAM%TYPE;BEGIN SELECT
SELECT * FROM V$VERSION
Latest Answer : To find the Oracle Version:Sql>Select * from v$version; ...
Latest Answer : If you use CASE , then optimize your query by adding /*+CHOOSE*/..This way case is faster than decode.Also if there any case where you need to use decode under decode then that would be cumbersome and trickier. Then it's better to use CASE. ...
I have small application that i was developing as a school evaluation project,but i have faced problems.(i.e) My command buttons are not perfoming the tasks as expected Edit, and Delete buttons they search and delete the first records on the database. A sample of the commands is as below i am using Using DAO in a module and listviews to display the records.Please helpPrivate Sub cmdEditer_Click()cmdsaved.Caption = "Update"Dim l As Integerl = Val(InputBox("Enter the suppliers Number
This is regarding Business Objects Univers creation.There are two objects which will be counting number of partners from table A based on two different conditions. Third object will calculate percent of (first object /second object). Example Z% = (X / Y) * 100When the same logic is implemented in BO, a query is being generated automatically and it is incorrect. It will be Select count (A.NBR)/ count (B.NBR) from A, B (It is alias of table A) where condition1 and condition2. Here condition1 and
How to calculate the power of decimal number?There is a function power(numeric,power) but when I use {select power(2.5,3)} truncate error occures but it works on power(2,3)
in the select clause there are few keywords like SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY.. i would like to know execution of the select statement means which one executes first out of these keywords
