Oracle PL/SQL

Oracle PL/SQL Toad for Oracle-How to make editor generate a script for tables,views,packages so that the script can be searched

Hello, I am using "Toad for Oracle" and i am trying to find a way to search for certain words and numbers in the comments in scripts. I know you could use the create a script button and then control f to search for the words in the script. But is their a way to do it using a query or to create a...

BULK COLLECT and FORALL in PL/SQL

How do I update multiple columns in a table using the BULK COLLECT... FORALL methods in PL/SQL.

Formatting PL/SQL code in SQL DEVELOPER

Hi Experts, I would like to know some keyboard shortcuts and clever formating on PL/SQL codes in SQL developer Pls hlp me out with some hints for this.. thanks n advance

PL/SQL

Hi Experts, I would like to mentione here i was trying to test one package and found the package has a procedure named SET() which hav UPDATE on Report table and INSERT on A_R table in same transaction Both the above mentioned tables hav a tim_upt column which s given as systimestamp and...

PL/SQL - Attribute to test not null and can take specific value instead

Hi Experts, How can we make a check on an attribute not null but can take - rather I have address 3 which can't take null instead - would be fine how this can be check n PL/SQL procedure

PL/SQL - How to make a check whether the attribute is positive or zero

Hi Experts, How to make a check on attribute(NUMBER) is positive or zero?

Replace a variable part of a string in a varchar2 field

I have a vendor Oracle table containing data as follows column name: PVC_Value value = TRKCASETRK;6,0,0,0,0,0,0;;20801911;32004910;43175007;2,2;0;59647;1,30;0;0;3002 As you can see this field contains data delimited by semi-colons (for 13 elements) I need to relace the 7th and 10th elements in...

Duplicate Sql

Hi, I want to know in a given PL/SQL Procedure or PL/SQL Function How to find the duplicate(i.e., Repeated) SQL Statements. regards, aditya.