How do you find the users who are running the script ?
Latest Answer: Use v$session view. ...
Please explain about Mutation error in database trigger in oracle with an example
1)How can restrict the view through view2)What does prior statement in pl/sql3)What are the different Pragam inPL/sql except Pragam_init,pragma_Automation
Latest Answer: you can write an after insert trigger to maintain the audit of that table. ...
I am running a queue handler process which polls oracle table at a particular frequency. After some 'n' number of polls oracle drops connection, where n is very large integer value. Can any one reason out, why oracle drops the connection.
Latest Answer: Through Dataconnections. ...
Latest Answer: Save your .xls file as .CSV file and use the SQL Loader ...
Latest Answer: generally we use partinioning for large databases ( if a huge collection of data is there). indexing is the first most process to fast query result, ...
There is a field of type character in the table, but we are storing numeric values like (Roll number) in this field, so if we want to sort the field (in java) according to numbers.How?
by creating a function for sorting in the front end(guessing, i am not sure. plz answer it)
View page [1] 2 3 Next >>
Go Top
