• 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:
  • 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:
  • insert and updat remote table

    am using a trigger to sync a remote table every time there is an update or insert on the local table. The columns are user-type object. The tirgger can not insert or update on the remote table. I get the following error: CUSTOMERS Table : ORA-22804: remote operations not permitted on object tables...

    T-REX5 pointsBadges:
  • Oracle table column names starting with a number

    Hello, I just finished creating MANY tables that have column names starting with a number. I didn’t realize it was an issue until I started trying to select data from my tables using the column names in the where clause. Inserts work. Selects without where work. Is there any way to keep the...

    Jaime0 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.

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