Excel File from PL/SQL Procedure
Hi, I have an Oracle PL/SQL procedure that creates a csv file with output. I would like to create an Excel spreadsheet with multiple tabs, seperate information in each tab. Can you advise how I achive this in PL/SQL. Thanks Heather

Answer Question   |  March 26, 2012  12:44 PM
excel, Oracle 10i, Oracle PL/SQL, PL/SQL

Oracle opportunities
I completed my B.E in 2009, so I want interested to go to oracle side, so I know the concept of sql and pl/sql. Relating to this I dont have a project of this. So please give me some titles of project atleast I can go through this.. regard@sadashiv

Answer Question   |  January 28, 2011  5:25 AM
Oracle, Oracle PL/SQL, Oracle projects, SQL

How can I generate an output file from two input files choosing data from each files using utl_file package or any other way?
I have two html files one is a template with certain data that must be transferred to the output file and the other file is also an html file which contains the most data that must be transferred to the same out put file. I have tried to write from both files to the output [...]

Answer Question   |  November 4, 2010  9:20 PM
Oracle 10g, Oracle 10g administration, Oracle PL/SQL, PL/SQL

search string in oracle DMP file
hi , i would like to write a pl/sql oracle code to search a string from Oralce DMP file. e.g <OWNER_NAME>[strong]xxx[/strong]</OWNER_NAME> i want to get  [strong]XXX[/strong] as output . any help would be really really appreciated      

Answer Question   |  October 15, 2010  12:01 AM
DMP Importing, Oracle, Oracle PL/SQL, PL/SQL, Search string

ORACLE-TRIGGERS
Hello, im going to create a trigger(insert or update) for a tableA, when it fires inserted or updated columns are should be insert or update into another table say tableB, one column(Processed_time) in tableB where its value will be by subtrcting two columns in tableA(response_time,Submission_time) all are timestamp type how to update(Processed_time) in tableB by [...]

Answer Question   |  July 1, 2010  11:46 AM
Oracle PL/SQL, Oracle SQL Developer, Oracle triggers, SQL Trigger

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 [...]

Answer Question   |  July 21, 2009  7:40 PM
Oracle, Oracle PL/SQL, PL/SQL, TOAD

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.

Answer Question   |  April 19, 2013  3:11 AM
BULK COLLECT statement, FORALL statement, Oracle PL/SQL, PL/SQL

Formatting PL/SQL code in SQL Developer
Hi experts, I would like to know some keyboard shortcuts and clever formatting on PL/SQL codes in SQL Developer. Please help me out with some hints for this. Thanks in advance.

Answer Question   |  April 18, 2013  5:49 AM
Oracle PL/SQL, Oracle SQL Developer, PL/SQL, PL/SQL block

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 strange it [...]

Answer Question   |  February 20, 2009  10:47 AM
INSERT statement, Oracle development, Oracle PL/SQL, PL/SQL, PL/SQL block, SQL, SQL Timestamp, Timestamp, UPDATE statement

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

Answer Question   |  February 9, 2009  11:13 AM
NOT NULL, NULL, Oracle development, Oracle PL/SQL, PL/SQL, 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?

Answer Question   |  February 10, 2009  4:55 AM
Oracle PL/SQL, PL/SQL, PL/SQL attributes, PL/SQL Variables

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 this string, so in the case above I need to replace the substring 2,2 with [...]

Answer Question   |  October 24, 2008  9:06 PM
Oracle PL/SQL, Oracle Table, VARCHAR

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.

Answer Question   |  September 2, 2008  3:40 AM
Oracle development, Oracle PL/SQL, SQL