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
Latest Answer: This error occurs when you try to select rows from a table and try to update the rows of the same table. Most developers face this problem. To avoid getting this error, create views, select the rows from the views, and then try ...
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: 1)How can restrict the view through viewAdding where clause2)What does prior statement in pl/sqlGenerate hierchy tree3)What are the different Pragam inPL/sql except Pragam_init,pragma_AutomationPragma_init - to trap the expection pragma_automation - to ...
Latest Answer: Most simple way is to write an Insert trigger on the table which you want to get audited. ...
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: it can be inserted using insert statement :="insert into R1 values('"&A2&"','"&B2&"','"&C2&"','"&D2&"','"&E2&"','"&F2&"','"&G2&"',"&H2&",'"&I2&"','"&J2&"','"&K2&"','"&L2&"','"&M2&"',"&N2&","&O2&",to_char("&P2&",mm/dd/yy);"into ...
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
