I have a stored procedure in Oracle and I\'m using an out 开发者_开发问答parameter in it.. I want to know how to display the output in Toad..You just need to declare a variable to store the value in,
开发者_JAVA百科My dynamic sql below to alter a table & create columns based on the output of a query is giving error.
I have some PLSQL code which loops through some logic: 开发者_StackOverflow中文版 FOR I in cur1 LOOP
Can anyone tell me how to translate the following T-SQL statement: SELECT fileld1 = CASE WHEN T.option1 THEN -1
guys. Say I have the following table: ID | String ---+--------- 1| <123><345> 2| <1-2><45-67>
I have two questions. (1) how to make move text file from folder: C:\\Data\\inbox\\test.txt to target Folder?
I have a problem in matching regular expression in Oracle PL/SQL. To be more specific, the problem is that regex doesn\'t want to match any zero occurrence.
In SQL Server we can type IsNull(开发者_开发问答) to determine if a field is null.Is there an equivalent function in PL/SQL?coalesce is supported in both Oracle and SQL Server and serves essentially t
i have some numb开发者_如何学JAVAers which i want to store in an array. how will i declare array and assign value to it in oracle pl/sql??There are array type in PL/SQL but we can create those ourselv
How can i return 2 values from a PL-SQL开发者_如何学运维 function?I would not advocate creating a function with an OUT parameter for the second value, because I like to think of functions as a pure co
加载中,请稍侯......