plsqldeveloper

相关标签：javascript jquery android 多少钱 iPhone

PL/SQL String Manipulation

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[详细]

2023-01-05 23:13 分类：问答
sql trigger error:invalid specification

i am creating a trigger and receiving some error, which i m not able to understand. Pls can anyone help me with that.[详细]

2023-01-05 10:02 分类：问答
Invoking a function call in a string in an Oracle Procedure

I writing an application using Oracle 10g. I am currently facing this problem. I take in \"filename\" as parameter of type varchar2.[详细]

2023-01-01 00:40 分类：问答
Simple Oracle Stored Procedure getting Invalid object error

I am trying to write a simple Oracle Stored Procedure: CREATE OR REPLACE PROCEDURE act.skeleton IS DECLARE[详细]

2022-12-30 06:31 分类：问答
DOT(.) after Ampersand (host variable)& considering as a part of variable name?

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)[详细]

2022-12-27 03:28 分类：问答
Upper Bound in FOR loop does not get altered in loop,Why?

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.[详细]

2022-12-27 03:22 分类：问答
Concatenation with Zero is not occurring properly in code?

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:[详细]

2022-12-25 08:56 分类：问答
Boolean data type size and want to print its value?

I want to know size of data typeboolean , i used VSIZE() functio开发者_如何转开发n but it is not working for boolean and[详细]

2022-12-25 06:39 分类：问答
to_date function pl/sql

undefine dates declare v_dateInput VARCHAR(10); v_dates DATE; begin v_dateInput := &&dates; v_dates := to_date(v_dateInput,\'dd-mm-yyyy\');[详细]

2022-12-24 20:05 分类：问答
scope of raise exception, handling your own exceptions in PLSQL code

I have this procedure: create or replace PROCEDURE CONVERTE IS CURSOR oldemployees IS SELECT * FROM emp1 WHERE data_saida= NULL;[详细]

2022-12-17 14:27 分类：问答