I need to split an address which is a single string into multiple strings. Below are the requirements to for the pl/sql procedure that splits up the address into the corresponding address lines. The p
i am creating a trigger and receiving some error, which i m not able to understand. Pls can anyone help me with that.
I writing an application using Oracle 10g. I am currently facing this problem. I take in \"filename\" as parameter of type varchar2.
I am trying to write a simple Oracle Stored Procedure: CREATE OR REPLACE PROCEDURE act.skeleton IS DECLARE
I know heading is not so clear.This isthe picture I am using &a开发者_StackOverflowmp;a it is considering it as $a. ,in the output &a and &a. is giving the same output. and why single .(DOT)
I am t开发者_StackOverflow社区rying to change the value of upper bound in For loop ,but the Loop is running till the upper bound which was defined in the starting.
I was trying to reverse a number in PL/SQL.It\'s working fine, but when my number contains any 0, the output is unexpected.For example:
I want to know size of data typeboolean , i used VSIZE() functio开发者_如何转开发n but it is not working for boolean and
undefine dates declare v_dateInput VARCHAR(10); v_dates DATE; begin v_dateInput := &&dates; v_dates := to_date(v_dateInput,\'dd-mm-yyyy\');
I have this procedure: create or replace PROCEDURE CONVERTE IS CURSOR oldemployees IS SELECT * FROM emp1 WHERE data_saida= NULL;
加载中,请稍侯......