plsql
How to manage user/permissions in an environment web/PL/SQL correctly?
My team will develop an internal (known users) application that has an architecture based on Java as front-end and PL/SQL as back-end. So, currently we are thinking in a better solution to manage the[详细]
2023-04-05 19:00 分类:问答PL/SQL variable declaration: Is it INOUT if i don't explicitly specify?
CREATE OR REPLACE PROCEDURE GET_DISCOUNT ( v_have_list SALES_PRODUCT_TY_LIST, ... ) Is v_have_list an INOUT variable开发者_StackOverflow?The default is IN.[详细]
2023-04-05 15:34 分类:问答How to get information about a User-Defined Type?
In simplicity, PL/SQL generally follow the following: DECLARE Variable declaration BEGIN Program Execution[详细]
2023-04-05 14:35 分类:问答Is there any way to apply TDD techniques for dev in PL/SQL
As I have a lot of program logics in DB-server-side in PL/SQL I would like to find out is TDD applicable to PL/SQL. Even more it would be very god if you point me at some information resources that ha[详细]
2023-04-05 01:41 分类:问答PL/SQL Comparing bit strings, I need an AND operation?
I currently have a script that calculates the tanimoto coefficient o开发者_StackOverflow中文版n the fingerprints of a chemical library. However during testing I found my implementation could not be fe[详细]
2023-04-05 00:18 分类:问答SQL Developer setting for Feedback
Is there a way to set the option set feedback o开发者_StackOverflow中文版n or set feedback off permanently in Oracle SQL Developer?A method of controlling options such as this is in SQL Developer is t[详细]
2023-04-04 15:41 分类:问答PL/SQL Server Pages - How does it compares to other technologies (e.g. PHP)? How popular is it? [closed]
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references,or expertise, but this question will likely solicit debate, a[详细]
2023-04-04 13:12 分类:问答pl/sql - compare record counts across 2 user's tables
I have table \'stf_table\' under the schema \'staff\' with username \'staff\'. I have table \'emp_table\' under the schema \'employee\' with username \'employee\'.[详细]
2023-04-04 07:48 分类:问答Using PL/SQL associative arrays
create or replace aArr is TABLE of varchar2 index by binary_integer; create or replace bArr is TABLE of varchar2 index by binary_integer;[详细]
2023-04-04 00:42 分类:问答oracle stored procedure - printing varchar2 output variable
I execute a stored proc as follows: var myOutput varchar2 exec myproc(:myOutput) print myOutput However, this does not work.[详细]
2023-04-03 19:14 分类:问答