| Thread | Last Post | Replies |
|
| Compare two rows | 05 Dec 2005 17:12 GMT | 2 |
rec1 testTable%ROWTYPE -- have substaniated this variable How can I reference a column in the record dynamically? eg: instead of using
|
| 8.1.7.4 - Linux - BLOB question | 05 Dec 2005 15:07 GMT | 2 |
Is there any way from within sqlplus that you can determine the size of a blob? thanks
|
| error in report | 05 Dec 2005 14:54 GMT | 1 |
These are the errror which i got when i run a report in oracle apps, Arguments ------------ p_ca_set_of_books_id='1'
|
| Where LMT bitmaps are added when you have zillions of extents ? | 05 Dec 2005 14:30 GMT | 1 |
Suppose you have a datafile in an LMT tablespace with so many extents that Oracle no more has the room to update its bitmap locator: where is the new bitmap extent
|
| How to backup ASM? | 05 Dec 2005 13:44 GMT | 4 |
I recently experimented with ASM and ran into a problem that neithe the manuals nor a web search could solve for me My problem is: How do I backup the ASM instance? There has to be som metadata in an ASM instance, since the SPFILE only contains the name
|
| Any1 knows what happened to tahiti? | 05 Dec 2005 10:44 GMT | 19 |
Been dead for over 24 hours now...
|
| Regarding reading records before a transaction started | 05 Dec 2005 09:57 GMT | 13 |
Hi Oracle Gurus, I had a bit peculiar requirement where I need to get the records/values for a table before the current transaction was started. The situation is as depicted below -
|
| Index organised table | 05 Dec 2005 01:25 GMT | 8 |
I am reading tom kytes Expert .... 1. I am unable to understand the statement "with IOT logical I/O would be the same, the physical I/O would be less"
|
| Is there any predefined Oracle constants there denominate very large number ? | 04 Dec 2005 20:09 GMT | 17 |
|
| Possibility to replicate an index | 04 Dec 2005 19:41 GMT | 2 |
anybody here who successfully replicated an non-primary-key to a materilized-view-site? Thanks in advance.
|
| Adding hints to PL/SQL? | 04 Dec 2005 19:18 GMT | 2 |
I have encountered an odd situation: Some PL/SQL code I have is exhibiting some interesting behavior (copyrights unfortunately do not allow me to repost someone else's code). In a rather straightforward way it joins DBA_SEGMENTS and
|
| .NET Stored procedures and Oracle 10g lite R2 | 04 Dec 2005 15:48 GMT | 11 |
Hello Team.. Does Oracle lite 10g R2 supports .NET stored procedures? Oracle document only show that they support Java SP but they didn't mention that it does not support .NET SP.
|
| MSSQL Table Variable Equivalent? | 04 Dec 2005 10:13 GMT | 11 |
Greetings All, I was hoping that someone might be to help me out. I was wondering if Oracle has a table data type like SQL server. This is just a variable that lives completely in memory and has many of the characteristics of a table. I need to be able to store a list of
|
| List clients running Oracle in Windows NT Network | 03 Dec 2005 21:30 GMT | 3 |
We have a Windows NT Domain with several clients running Oracle; we need to list out the clients which are running Oracle. Is there any way or tool available to do that ? Thanks in advance,
|
| Beginner SQL question (on intersecting groups of records).... | 03 Dec 2005 21:13 GMT | 2 |
Hi there, I need to ship something from A to B. I have a group of trains T1 that leave station A and head out, and another group of trains T2 that I know go to station B. I want to find out what pairs of trains from T1 and T2 can take me from
|