-
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
