Posted
by Vabs
on Stack Overflow
See other posts from Stack Overflow
or by Vabs
Published on 2010-04-13T08:07:59Z
Indexed on
2010/04/13
8:13 UTC
Read the original article
Hit count: 239
I have a column with comma separated values like 6,7,99.3334. I need write a PL SQL procedure that will give me these values separately. The Length of the column is 40.
Can anyone help me with this?
© Stack Overflow or respective owner
as seen on Oracle Blogs
- Search for 'Oracle Blogs'
Oracle OpenWorld 2012 is almost here! We're looking forward to updating you on our products, strategy, and roadmaps. This year, the E-Business Suite Applications Technology Group (ATG) will participate in 25 speaker sessions, two Meet the Experts round-table discussions, five demoground booths and…
>>> More
as seen on Oracle Blogs
- Search for 'Oracle Blogs'
Welcome to our countdown to Oracle OpenWorld!
Oracle OpenWorld 2012 is just around the corner. In less than
26 days, San Francisco will be invaded by an expected 50,000 people from all
over the world. Here on the Oracle WebCenter team, we’ve all been working to
help make the experience a great…
>>> More
as seen on Oracle Blogs
- Search for 'Oracle Blogs'
Database ??
Database ???????
Database ??????????
Java
WebLogic Server/????????·????
SOA/BPM/?????
???????/????
ID??/??????
?????EPM/BI
EPM/BI ???????
EPM/BI ????
OS/???
????
?????
MySQL
Database ??
????
??
?????????
???
??
ORACLE MASTER…
>>> More
as seen on Oracle Blogs
- Search for 'Oracle Blogs'
SOA PARTNER COMMUNITY NEWSLETTER JULY
2012
Dear
SOA partner community member
To
provide our community members the best of our knowledge, we want your feedback
on our SOA Partner community. Thus we are organizing SOA Partner Community Survey 2012. We…
>>> More
as seen on Oracle Blogs
- Search for 'Oracle Blogs'
Below is the schedule for all ADF related sessions at a glance. Note the Meet and greet session added for Wednesday Octiber 3rd from 4.30 pm to 5:30.
Oracle ADF and Fusion Development
General Session
Mon 1 Oct,…
>>> More
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
