1
  • How can I write a trigger that fires everyday at night 9′o clock?

    Actually I'm developing a project I want to write a trigger that should fire every day at night 9'o clock and that trigger should copy data from one table to another table.

    gowthamgk85 pointsBadges:
  • 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?

    Inprise610 pointsBadges:
  • 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.

    RangjungDorje20 pointsBadges:
  • 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.

    Inprise610 pointsBadges:
  • 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

    HeatherM5 pointsBadges:
  • 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

    Ingalagi5 pointsBadges:
  • 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 file inside two loops....

    Techguys90 pointsBadges:
  • 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      

    Balajikalai15 pointsBadges:
  • 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)...

    RizwanSharief30 pointsBadges:
  • 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...

    Dug50 pointsBadges:
  • 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...

    Inprise610 pointsBadges:
  • 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

    Inprise610 pointsBadges:
  • 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...

    JoeA15 pointsBadges:
  • 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.

    Garimella5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following