Posted
by Artic
on Stack Overflow
See other posts from Stack Overflow
or by Artic
Published on 2010-03-12T07:11:29Z
Indexed on
2010/03/14
20:25 UTC
Read the original article
Hit count: 265
Have a lot of unnecessary results using contains() method in my query. Don't tell me to use like or something else. It is hardcoded and couldn't be changed.
© Stack Overflow or respective owner
as seen on Stack Overflow
- Search for 'Stack Overflow'
If I use many CLOB variables in the PL/SQL stored procedure to store many long length string , are there any performance issues? Is the length of the CLOB is also variable? Are there any known limitations/disadvantages for CLOB instead using varchar2 and long?
>>> More
as seen on Oracle Blogs
- Search for 'Oracle Blogs'
Everyone knows that SQL Developer has a PL/SQL debugger – check!
Everyone also knows that it’s only setup for debugging standalone PL/SQL objects like Functions, Procedures, and Packages, right? – NO! SQL Developer can also debug your Stored Java Procedures AND it can debug your…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have the following query that runs in my Oracle database and I want to have the equivalent for a SQL Server 2008 database:
SELECT TRUNC( /* Midnight Sunday */
NEXT_DAY(SYSDATE, 'SUN') - (7*LEVEL)
) AS week_start,
TRUNC( /* 23:59:59 Saturday */
NEXT_DAY(NEXT_DAY(SYSDATE…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I know in C like languages logical operators are evaluated one at a time so:
false && really_expensive_function()
is doesn't result in the function being called (I can't remember the CS name for this). Does the same happen in PL/SQL or do I need to break the IF parts out to separate blocks?
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I searched for this topic on SO but I did not found any recommendations and so am asking it as I am new to PLSQL and want to understand it:
What is best way to get started with PLSQL ?
What are best online resources or books available out there for understand PLSQL which you would recommend ?
Do…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
I am working on a product that must support both MSSQL and Oracle (10g and 11g). I have some very complex queries that seem to run without issue on MSSQL 2005/2008, but very, very slow with Oracle. The CPU on the oracle server skyrockets for long periods of time, and it seems like the optimizer…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I just want to give you a little background
Need to write a PL-SQL which will extract 6 million record joining different tables and create a file of that.
Need more suggestions, specifically on how to fetch these many records. As fetching these million of records on a single go can be a highly resource…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
What to use in oracle 10G to extract 6 million records and create a flat file of it ?
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi guys,i want to know how can we know the other users of oracle 10g on the same system.
Is there any querry for that?
thank you!!!
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I am looking for a newer version of the Pro*C/C++ to upgrade my procui.exe 9.0.1.1.1.
I downloaded the 10g client disk and when install I have the following options:
instant client
administrator
runtime
custom
I dont seem to able to find the actual program other than just getting some…
>>> More
