Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
I have written PL/SQL code to store XML into cursor. Refer the below code Requirement: As of line at line 83, I am inserting the result into another table (XML_GEN) as XMLTYPE datatype. Line: insert into xml_gen (fxdoc) values (i.FXML); But ...
Hi there, Is there any function in SQL or PL/SQL to add space to string value ? for example : this value 'oraask' i need the result to be like this : 'ora ask' thanks in advance.
Hi, Please i am trying to use dbms_assert package in a SQL statement and I want to understand exactly how dbms_assert protects against SQL injection ? thanks.
suppose we have created new directory on database server and give it required privileges like : [code]CREATE OR REPLACE DIRECTORY TEST_DIR AS '/usr/tmp'; GRANT READ, WRITE ON DIRECTORY TEST_DIR TO MYUSER;[/code] Now i want to know if oracle has capable to read and ...
for example I have one table with unique constraint on ID column and it has values like this : ID Name 1 test and I want to catch and handle unique constraint exception. thanks
hello, I'm using Oracle 10gR2 and i want to know what's the differences between both because I take a look at the documentation and i find out there no differences. any suggestions will be appreciated.
How to drop all partitions from all tables belonging to this schema based on date Hi, I have a script to delete the partition from a table which meet certain criteria and this the block of code to do this : DECLARE v_sql varchar2(500); v_date ...
I face this error when I want to execute this block of code in an anonymous pl/sql block: DECLARE BEGIN SELECT last_name INTO v_last FROM employees; dbms_output.put_line('v_last is :' || v_last ); END; PLS-00201: identifier must be declared thanks.
please i want to know all differences between procedure and function in oracle pl/sql thanks in advance.
What are the PL/SQL Program limits ?
