oracle11g
Oracle11g audit审计配置全过程
目录一、audit是什么?二、启用audit三、配置标准审计四、审计记录管理1.查看审计记录2.清理审计记录总结一、audit是什么?[详细]
2024-10-09 09:01 分类:数据库Finding Duplicate Data in Oracle
I have a table with 500,000+ records, and fields for ID, first name, last name, and email address. What I\'m trying to do is find rows where the first name AND last name are both duplicates (as in the[详细]
2023-04-13 06:43 分类:问答Does indexes work with group function in oracle?
I am running following query. SELECT Table_1.Field_1, Table开发者_如何学Python_1.Field_2, SUM(Table_1.Field_5) BALANCE_AMOUNT[详细]
2023-04-13 06:07 分类:问答Hibernate fails to open Connection with Oracle 11g?
I made a basic JUnit test to set up this Oracle database on my computer with hibernate. The database works and everything, but trying to hook it up to Hibernate is proving to be a challenge. My config[详细]
2023-04-13 04:23 分类:问答External Tables - "partial record at end of file" error when using FIXED
I am getting a \"partial record at end of file\" error when using FIXED parameter with External Tables.[详细]
2023-04-13 03:31 分类:问答How to improve Performance with Oracle SQL Join
The situation is I have to join more than 10 differ开发者_C百科ent table. In the SQL I am joining the same table 5 times. The query looks like this.[详细]
2023-04-12 18:57 分类:问答bulk collect in oracle
How to query bulk collection?If for example I have select name bulk collect into namesValues 开发者_StackOverflow中文版from table1[详细]
2023-04-12 18:52 分类:问答Error while calling sql from unix shell script
I have a shell script running on unix. Like this: $ORACLE_HOME/bin/sqlplus -s \'/ as sysdba\' <<EOF[详细]
2023-04-12 13:01 分类:问答How can I get the best Hierarchical Query performance in oracle
I have a table reply of which structure is following: Idnameparent_id ... 1reply10 2reply21 3reply32 4reply43[详细]
2023-04-12 12:39 分类:问答Oracle security policy
How to Create a FUNCTION that restrict users to seeing only employees with a salary of 1,500 or less ?? As an example: if i enter[详细]
2023-04-11 22:49 分类:问答