• How can I join 3 tables using JOIN keyword

    Hi Experts, Pls hlp me with my query How can i join 3 tables using JOIN Keyword inside PL/SQL block in SELECT ... WHERE clause Query 3 Tables namely Reg,ROOTS,ME and the select statement takes both parameter variable and local variable Thanks!!!!!

    Inprise610 pointsBadges:
  • Number precision

    What is the default precision of a variable declared as a datatype "NUMBER" in pl/sql

    Mahe10 pointsBadges:
  • “a program is trying to automatically send e-mail on your behalf” in D2k form

    whenever i send mail automatically throug D2K forms&Report I get a Message 'a program is trying to automatically send e-mail on your behalf'. i t will ask for a confirmation yes or no' it goes every time to the user. now if user will click on no then this mail will not go. so i want pl/sql coding...

    44063860 pointsBadges:
  • I would like to know the procedure name

    How to know the procedure name of itself? for example, ------------------------------ create or replace procedure my_proc1 is begin dbms_output.put_line (' procedure name =>' || xxxxxx ) ; end; ----------------------------- i want to print 'my proc1' as procedure name through...

    Gregori15 pointsBadges:
  • do_while how can i use do while statement to delete certain rows based on the rowcount?

    how can i use do while statement to delete certain rows based on the rowcount??

    Mahe10 pointsBadges:
  • PL/SQL – select data – group by- having?

    I need to select all names where Value EITHER a or b. how do I do that?/thnks Sample: Num Name Value 1 Ann a 2 Ann b 3 Julia a 4 Julia b 5 Peter a 6 Jnohn b

    Julctm15 pointsBadges:
  • my question

    How to find the repeating charactar or letter in a string like 'information' in pl/sql or sql .

    Maneswar15 pointsBadges:
  • PLSQL based method to capture emails from POP server

    I am using UTL_TCP package of PLSQL. I am able to connect to the POP server but I am unable to retrieve any email content. Using the UTL_TCP.available() method, I am getting the returned number of bytes as Zero inspite of their being an email. I tested the telnet commands againt the POP server &...

    Monk10 pointsBadges:
  • how can i resolve oracle error 00103

    I am getting the following error when running the below procedure from TOAD. I have ora 9i OS Windoes XP. CREATE OR REPLACE PROCEDURE SP_CALL_PROCEDURE22 (BUSINESS_UNIT1 in varchar2) IS CURSOR C1 IS SELECT BUSINESS_UNIT,VOUCHER_ID,INVOICE_ID,VENDOR_ID,GROSS_AMT FROM PS_VOUCHER WHERE BUSINESS_UNIT=...

    150919745 pointsBadges:
  • Inserting without duplicating

    I need to create a row and to ensure that the row I'm creating does not already exist. I'm doing this in a pl/sql program.

    Marlin325 pointsBadges:
  • job problem

    i create a job for updating table and make auto drop after that , the problem that when i create this job, one time it's created and one time not , in regular way , and this is the procedure. begin dbms_scheduler.create_job( job_name => 'DropIp_test', job_type => 'plsql_block', job_action...

    Abdo5 pointsBadges:
  • what is the diff between cursor and plsql table

    what is the diff between cursor and plsql table

    Saritha55 pointsBadges:
  • Create a PL/SQL block that will insert new records into the StoreRoom_info table. The PL/SQL block must use substitution variables to prompt the user

    Create a PL/SQL block that will insert new records into the StoreRoom_info table. The PL/SQL block must use substitution variables to prompt the user information. Check that the Region_id is between the values 1,2,3,4 or 5. If not found, the block must display a user friendly message notifying the...

    VB RD45 pointsBadges:
  • How to capture emails with attachments from the POP server using Pl/SQL ?

    I am able to retrieve emails from POP server using UTL-TCP package of PL/SQL. I am also able to retrieve Attachment with the email, but the contents of the Attachment are displayed as some random string of characters. Can anyone tell me how can I access the contents of the Attachment in...

    Monk10 pointsBadges:
  • What causes ora-00904 error on valid fields when querying across dblink in a cursor

    I have a procedure that contains a cursor that runs in a cursor for loop. The select query runs fine over the dblink all by itself, but when I try to compile the procedure, I get the PL/SQL: ORA-00904: invalid identifier on the column names. I can do a describe on the table over the link and all of...

    Tom msu15 pointsBadges:
  • Need help with a slow pl/sql script

    Hello. I am running this script and it is taking over 3 hours on Oracle 10. Can anyone help. ---------------------------------- spool noaddressusagerelfix.LOG set timing on; SET SERVEROUT ON; DECLARE vpartyCustomerNo TableB.I_OCPRTY_USAGES%TYPE; vI_OCPOSTAD_USAGES TableB.I_OCPOSTAD_USAGES%TYPE;...

    Darrankavanagh20 pointsBadges:
  • Pl/sql code for queries

    Hi , I have written 4 sql queries.2 select commands and 2 delete commands.now I want to write a pl/sql block for this.i.e after 2 select statements if the given condition satisfies then 1st delete command applicable. same way for 2nd delete command.I want to write cusor for those 2 select...

    User714085 pointsBadges:
  • Running Procedures within the PL/SQL program

    WE are dealing with stored procedures in a PL/SQL program. I am trying to execute the procedure from within the program itself. Is there a need to do it within a cursor or is there a specific manner to do that?!

    Nimsalwayz5 pointsBadges:
  • Truncate or not Truncate SQL

    What are the pros/cons of truncate a table export/import to just drop table?

    Jay Dog5 pointsBadges:
  • HOw to Find Duplicate Geometry in Oracle Spatial

    If anyone knows a SQL statement for Oracle spatial on how to find duplicate geometry for area, line and point features, I would much appreciate it if she\he can share this with me. A million thanks in advance... Regards, Sam

    SamAvella30 pointsBadges:

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.

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

Following