Top "Oracle10g" questions

ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)

I created a Windows 2003 R2 Virtual Machine running on VirtualBox and I installed Oracle (10201_database_win32). I assigned a static …

oracle10g windows-server-2003 virtualbox

How does contains() in PL-SQL work?

Have a lot of unnecessary results using contains() method in my query. Don't tell me to use like or something …

sql oracle oracle10g contains

How to determine MAXSIZE of existing tablespace

I need to determine the MAXSIZE that was set for a tablespace when it was created (Oracle 10g) I'm sure …

oracle oracle10g tablespace

How to get datetime in 24hour format from oracle database?

Is there any other way to get datetime field from oracle database in 24hour format???like -> "select getxsddate(…

oracle10g

How to clear all cached items in Oracle

I'm tuning SQL queries on an Oracle database. I want to ensure that all cached items are cleared before running …

sql oracle caching oracle10g

How can I check the last time stats was run on Oracle without using OEM

I want to check the last time stats was run on my Oracle 10g server. I would normally do this …

oracle oracle10g sqlplus statistics

JPA primary key auto generate

my primary key entity look like below @GeneratedValue(strategy= GenerationType.TABLE) private Long id; when i run, i get error …

java hibernate orm jpa oracle10g

How to delete a user in Oracle 10 including all it's tablespace and datafiles

When I give the command to drop a user i.e. DROP USER 'username' cascade, Does it deletes all the …

oracle10g

how do i clear oracle execution plan cache for benchmarking?

On oracle 10gr2, i have several sql queries that i am comparing performance, but after first run, the v$sql …

sql oracle10g

What is rowID & rowNum (ROWID vs ROWNUM)

I'd like to know difference between rowID and rowNUM And how to see both of these in our table. when …

sql oracle10g rownum rowid