oracle
Querying Oracle PLSQL
This is the error message I get when I run the below scripts ERROR at line 1: ORA-00979: not a GROUP BY expression[详细]
2023-04-12 04:41 分类：问答FluentNHibernate on a Oracle database, nullable foreignkey (Classic issue?)
Im in a bit of a jam. Problem NHibernate forces me to make a foreignkey column nullable, which is a very bad idea for our database and quite ugly.[详细]
2023-04-12 03:59 分类：问答Perform .NET Action on Database Change
We have a process that needs to fire when a change occurs to a specific database table in Oracle. At the moment a similar process has been developed using triggers and a bunch of subsequent database a[详细]
2023-04-12 00:54 分类：问答Avoid locks in Oracle UPDATE command
If I am trying to acquire a lock in Oracle 10g (e.g. with SELECT...FOR UPDATE), there is a NOWAIT option to get an error when the row is locked, instead of the query just hanging. Is there a way to ac[详细]
2023-04-12 00:43 分类：问答SQL for columns A, B, C: group by A, compute share of B equals C for each A
Database is Oracle. I have a single table with three columns, A, B and C. A is a string column B is an int column[详细]
2023-04-11 23:59 分类：问答What is causing spikes for JDBC calls to Oracle from within Websphere?
I was wondering whether someone can shed some light on the following issue: We\'ve been seeing spikes for JDBC calls from within a Spring 2.5.6 based web service run on Websphere 6.1 on AIX for calls[详细]
2023-04-11 23:15 分类：问答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 分类：问答Mapping POCOs in "schema.tablename" format in EF 4.1 code first, using dotconnect for Oracle
I have this entity: public class MyEntity { [Key] public int Id { get; set; } public string Name { get; set; }[详细]
2023-04-11 22:46 分类：问答Underlying mechanism in firing SQL Queries in Oracle
When we fire a SQL query like SELECT * FROM SOME_TABLE_NAMEunder ORACLE What exac开发者_StackOverflowtly happens internally?Is there any parser at work? Is it in C/C++ ?[详细]
2023-04-11 22:35 分类：问答Permission denied to edit a file in UNIX
I have a file created by oracle user with permission rw-r--r-- and the parent folder has rwxrwsr-x permission. Now, there is a requirement for batch user to edit this file. But, as you can see, the fi[详细]
2023-04-11 22:30 分类：问答
加载中,请稍侯......