Oracle PL/SQL

Contact owners and managers

1–30 of 963

0 selected

Ninja Li, Charls K V2

11/10/18

Pass XML string to web service using UTL_HTTP

Hi Nick, I am getting the same error message for one of my web service calls. I too have two

unread,

Pass XML string to web service using UTL_HTTP

Hi Nick, I am getting the same error message for one of my web service calls. I too have two

11/10/18

Gayathri, … ddf3

9/1/15

On Wednesday, August 26, 2015 at 3:00:30 PM UTC-6, GD wrote: Hi All, I have a scenario similar to

unread,

On Wednesday, August 26, 2015 at 3:00:30 PM UTC-6, GD wrote: Hi All, I have a scenario similar to

9/1/15

VinhBuu To, … Michael Moore3

4/10/15

Using collection in object type

Why do you want to use Objects in PL/SQL? I am curious because I've never found a justification

unread,

Using collection in object type

Why do you want to use Objects in PL/SQL? I am curious because I've never found a justification

4/10/15

A Sundar, … Michael Moore3

4/9/15

Need assistance in trigger creation

The only thing I would do differently is to use TIMESTAMP(6) instead of SYSDATE because sometimes

unread,

Need assistance in trigger creation

The only thing I would do differently is to use TIMESTAMP(6) instead of SYSDATE because sometimes

4/9/15

3/25/15

Oracle regular expression alternate possibilities

David, Thanks for your kind help and that explains it. I really appreciated it. Nick Li On Wednesday,

unread,

Oracle regular expression alternate possibilities

David, Thanks for your kind help and that explains it. I really appreciated it. Nick Li On Wednesday,

3/25/15

Ion Dijkstra, Michael Moore2

2/12/15

How to force a numeric value into a string?

This does not look like PL/SQL to me. What computer language are you trying to use? On Thu, Feb 12,

unread,

How to force a numeric value into a string?

This does not look like PL/SQL to me. What computer language are you trying to use? On Thu, Feb 12,

2/12/15

1/28/15

Is it possible to truncate the table before shutdown on trigger

On Monday, January 26, 2015 at 10:33:14 PM UTC-7, sundar wrote: Hi, How to truncate the table before

unread,

Is it possible to truncate the table before shutdown on trigger

On Monday, January 26, 2015 at 10:33:14 PM UTC-7, sundar wrote: Hi, How to truncate the table before

1/28/15

A Sundar, … ddf4

1/7/15

Wrapped code with comment line became invalid

On Saturday, November 8, 2014 5:26:16 AM UTC-7, sundar wrote: Hi, Thanks for your input on this. This

unread,

Wrapped code with comment line became invalid

On Saturday, November 8, 2014 5:26:16 AM UTC-7, sundar wrote: Hi, Thanks for your input on this. This

1/7/15

Dan H, … Aaron G8

11/6/14

User defined function returns VARCHAR2 at Max size

Thanks for this! On Tuesday, October 26, 2010 1:52:02 PM UTC-5, Michael Moore wrote: Now I understand

unread,

User defined function returns VARCHAR2 at Max size

Thanks for this! On Tuesday, October 26, 2010 1:52:02 PM UTC-5, Michael Moore wrote: Now I understand

11/6/14

9/23/14

Spool issue in 10g - please help

On Friday, September 19, 2014 5:00:30 PM UTC-6, sid ra wrote: SQL> SPOOL V:\mushtaq_DATABASE_LAB3.

unread,

Spool issue in 10g - please help

On Friday, September 19, 2014 5:00:30 PM UTC-6, sid ra wrote: SQL> SPOOL V:\mushtaq_DATABASE_LAB3.

9/23/14

A Sundar, … ddf4

9/9/14

How to validate the username and password inside the stored procedure

On Tuesday, September 9, 2014 10:18:25 AM UTC-6, sundar wrote: Thanks for your update. Is it possible

unread,

How to validate the username and password inside the stored procedure

On Tuesday, September 9, 2014 10:18:25 AM UTC-6, sundar wrote: Thanks for your update. Is it possible

9/9/14

Animesh Kumar, Michael Moore4

7/28/14

Retrieving value of variable based on variable name stored in table.

DECLARE lconst VARCHAR2(4000); BEGIN FOR rec IN (SELECT * FROM value_set) LOOP IF rec.value_type =

unread,

Retrieving value of variable based on variable name stored in table.

DECLARE lconst VARCHAR2(4000); BEGIN FOR rec IN (SELECT * FROM value_set) LOOP IF rec.value_type =

7/28/14

A Sundar, Michael Moore2

7/25/14

How do i get the physical read write io for whole session in plsql?

I don't have a direct answer for you, but If I wast trying to figure it out, I would use TOAD and

unread,

How do i get the physical read write io for whole session in plsql?

I don't have a direct answer for you, but If I wast trying to figure it out, I would use TOAD and

7/25/14

4/21/14

Failure on Bulk insertion

On Monday, April 21, 2014 12:34:03 AM UTC-6, weird0 wrote: I was asked this question in an interview.

unread,

Failure on Bulk insertion

On Monday, April 21, 2014 12:34:03 AM UTC-6, weird0 wrote: I was asked this question in an interview.

4/21/14

4/4/14

Re: Fetching First Max and Second Max for each person

From my ALCATEL ONE TOUCH T'Pop Gopakumar Pandarikkal <panda...@gmail.com> wrote: >

unread,

Re: Fetching First Max and Second Max for each person

From my ALCATEL ONE TOUCH T'Pop Gopakumar Pandarikkal <panda...@gmail.com> wrote: >

4/4/14

Jyothi Kavasseri, … Ashish Barot14

2/25/14

Using decode with dates

In this condition, if doc status is "R" and parameter date minus 10feb2014 is positive

unread,

Using decode with dates

In this condition, if doc status is "R" and parameter date minus 10feb2014 is positive

2/25/14

Serious_Developer, Michael Moore4

12/6/13

String Capabilities

I would use a CLOB datatype to the table column and use PL/SQL for process logic. On Fri, Dec 6, 2013

unread,

String Capabilities

I would use a CLOB datatype to the table column and use PL/SQL for process logic. On Fri, Dec 6, 2013

12/6/13

11/24/13

Re: [PL/SQL] Digest for oracle-plsql@googlegroups.com - 2 Messages in 1 Topic

Woh! its very interesting codeproject.com, is very understandable to me and easy Thank you very much

unread,

Re: [PL/SQL] Digest for oracle-plsql@googlegroups.com - 2 Messages in 1 Topic

Woh! its very interesting codeproject.com, is very understandable to me and easy Thank you very much

11/24/13

m shiva, Michael Moore2

11/22/13

Re: [PL/SQL] Digest for oracle-plsql@googlegroups.com - 3 Messages in 2 Topics

Try this link. https://www.google.com/search?q=documents+on+Oracle+Cursor's&oq=documents+on+

unread,

Re: [PL/SQL] Digest for oracle-plsql@googlegroups.com - 3 Messages in 2 Topics

Try this link. https://www.google.com/search?q=documents+on+Oracle+Cursor's&oq=documents+on+

11/22/13

xX_VP_Xx, … Michael Moore17

11/21/13

Stored Procedure Help

Do you have a specific question? On Wed, Nov 20, 2013 at 10:59 PM, Rajesh <sivasu...@gmail.com

unread,

Stored Procedure Help

Do you have a specific question? On Wed, Nov 20, 2013 at 10:59 PM, Rajesh <sivasu...@gmail.com

11/21/13

Vijay Patel, … ddf5

11/21/13

On Wednesday, November 20, 2013 7:31:39 PM UTC-7, Michael Moore wrote: I think you would have to

unread,

On Wednesday, November 20, 2013 7:31:39 PM UTC-7, Michael Moore wrote: I think you would have to

11/21/13

Google Talk, ddf2

11/14/13

Invitation to use Google Talk

On Wednesday, November 13, 2013 11:49:24 PM UTC-7, Google Talk wrote: -------------------------------

unread,

Invitation to use Google Talk

On Wednesday, November 13, 2013 11:49:24 PM UTC-7, Google Talk wrote: -------------------------------

11/14/13

Rajesh, … ddf4

10/28/13

ORA-01427: single-row subquery returns more than one row

On Monday, October 28, 2013 12:00:41 AM UTC-6, Rajesh wrote: Hi all, delete from emp1 where sal=(

unread,

ORA-01427: single-row subquery returns more than one row

On Monday, October 28, 2013 12:00:41 AM UTC-6, Rajesh wrote: Hi all, delete from emp1 where sal=(

10/28/13

10/14/13

How to connect PL/SQL developer and SQL PLus to Oracle 11g

On Monday, October 14, 2013 7:53:12 AM UTC-6, weird0 wrote: Upon trying the username and password on

unread,

How to connect PL/SQL developer and SQL PLus to Oracle 11g

On Monday, October 14, 2013 7:53:12 AM UTC-6, weird0 wrote: Upon trying the username and password on

10/14/13

Phil W, … Michael Moore14

10/2/13

SQL all word permutations challenge!

Yes if the order is discounted as we'd just be after the distinct set of equivalents. Yes, the

unread,

SQL all word permutations challenge!

Yes if the order is discounted as we'd just be after the distinct set of equivalents. Yes, the

10/2/13

Tareg Ali, … Michael Moore4

9/18/13

upload subscriber list

lol On Wed, Sep 18, 2013 at 9:53 AM, ddf <ora...@msn.com> wrote: On Wednesday, September 18,

unread,

upload subscriber list

lol On Wed, Sep 18, 2013 at 9:53 AM, ddf <ora...@msn.com> wrote: On Wednesday, September 18,

9/18/13

9/3/13

MIgration Testing

On Wednesday, August 28, 2013 9:15:32 AM UTC-6, Akshay T wrote: Suppose we've old_table in MS/SQL

unread,

MIgration Testing

On Wednesday, August 28, 2013 9:15:32 AM UTC-6, Akshay T wrote: Suppose we've old_table in MS/SQL

9/3/13

Tareg Ali, … SANTOSH NIKAM4

9/1/13

Thank Q you ... On Thursday, August 29, 2013 3:24:52 PM UTC+3, Tareg Ali wrote: hi guys .. i want to

unread,

Thank Q you ... On Thursday, August 29, 2013 3:24:52 PM UTC+3, Tareg Ali wrote: hi guys .. i want to

9/1/13

Manju Harish, … Michael Moore3

7/24/13

Send SMS Procedure

I don't really have an answer for your question, but have you considered sending email instead to

unread,

Send SMS Procedure

I don't really have an answer for your question, but have you considered sending email instead to

7/24/13

Lokesh ND, ddf4

7/24/13

Problem While creating Connection in SQL Developer

On Monday, July 15, 2013 10:46:13 PM UTC-6, Lokesh ND wrote: Hi David, I have installed Oracle 11g

unread,

Problem While creating Connection in SQL Developer

On Monday, July 15, 2013 10:46:13 PM UTC-6, Lokesh ND wrote: Hi David, I have installed Oracle 11g

7/24/13

Search

Clear search

Close search

Google apps

Main menu