oracle
Oracle 11g Creating a custom event trigger
how to Create a Database event trigger called as AuditErr that will fire every time a server error occurs. The[详细]
2023-04-11 22:19 分类:问答what does the "2"mean in SQL*Plus?
I am new to Oracle. And I have come across a problem. Firstly,I want to check the privileges of the sysman account:[详细]
2023-04-11 22:05 分类:问答oracle regular expression - search for a particular string
I have a data in a column like this Test 20019-2000 test Test 119 test Test 19-EM Test EM - 19 SO, when I开发者_如何学JAVA do a REGEXP_LIKE(mesage,\'19\') it is retrieving all the 4 records. But my[详细]
2023-04-11 21:55 分类:问答Error 201 select identifier must be declared
I am trying to make a login form through Oracle\'s Form Builder, I have a table called TRAVEL_USER which I made in SQLPlus.[详细]
2023-04-11 21:32 分类:问答Oracle: What should I know about SGA? [closed]
开发者_运维问答 It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical andcannot be reasonably answered in its current form.[详细]
2023-04-11 21:21 分类:问答how to execute several ddl words with batch processing
When I deploy my asp.net application,I have to create some tablesapces/users,I use the pqsql,however I want to know is there any way I can create them with batch processing?[详细]
2023-04-11 20:45 分类:问答Oracle error:- LRM-00116: syntax error at 'control' following '='
Oracle DB/Windows XP:- I am running an batch file开发者_StackOverflowthat calls an“.ctl” filewhich in turn calls an “.xls” file, both present in the same folder.[详细]
2023-04-11 20:18 分类:问答Java Hibernate + Oracle 11.2 Locking
I need to synchronize my user table with repository(the other DB) during application startup. I have two Tomcat nodes with Apache mod_jk. So when I restart both of them I make double inserts and doubl[详细]
2023-04-11 19:39 分类:问答SQL - Oracle Database 10g Group By Queries
I am currently having an issue with the GROUP BY statements in Oracle Database 10g with my database. I have four tables in this database - Advertisements, Staff, StaffGrade and StaffOnAd. What I\'m t[详细]
2023-04-11 19:32 分类:问答Difference Between Drop And Drop Purge In Oracle
I am using Oracle Database and I am a bit confused about Drop and Purge Commands. In fact for me both does the same thing. Removes the t开发者_JS百科able with schema from database. What is the main di[详细]
2023-04-11 19:03 分类:问答