oracle11g
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 - Modify an existing table to auto-increment a column
I have a table with the following column: NOTEIDNUMBER NOT NULL, For all intents and purposes, this column is the primary key.This table has a few thousand rows, each with a unique ID.Before, the a[详细]
2023-04-11 13:17 分类:问答calculating oracle users average session time [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. For help clari[详细]
2023-04-11 12:54 分类:问答Oracle 11 Index only for part of the data
I\'m using a table a table called T and have a column called C_I (Index) and C_D (Data). Now I would like to only have the row in the index if C_D = null.[详细]
2023-04-11 09:54 分类:问答Cannot lookup row in database by UUID RAW(32)
I have the following table: create table Mike_Test ( Idraw(32)default sys_guid() not null primary key, Valuevarchar2(80) not null unique[详细]
2023-04-11 06:48 分类:问答How can I combine two columns into a one LIKE statement?
I have a lastname and a firstname. I need to be able to search for smith or smith j. I have this in my where clause:[详细]
2023-04-11 05:39 分类:问答Oracle 10g (Win 64-bit) installation on Windows 7 64 bit fails [closed]
Closed. This question is off-topic. It is not currently accepting answers. 开发者_JS百科 Want to improve this question? Update the question so it's on-topic for Stack Overflow.[详细]
2023-04-11 05:15 分类:问答Oracle ORA-01805 on Oracle 11g database
Our Oracle 10g database was recently upgraded to 11g. The database is running on a Windows Server 2003 X64 machine. In SQL queries from a .NET application that access a table that has a TIMESTAMP (6)[详细]
2023-04-11 01:07 分类:问答C, unixODBC, oracle and Date queries
I\'ve got a query like select x from tableName where startDate <= now; When i query the database without the date fields, everything works as expected. As soon as i start using date or timestamp[详细]
2023-04-10 13:47 分类:问答How can I speed up loading data in Oracle tables?
I have some very large tables (to me anyway), as in millions of rows.I am loading them from a legacy system and it is taking forever.Assuming hardware is ok that is fast.How can I speed this up?I have[详细]
2023-04-10 07:17 分类:问答