Tag: plsql

Found 155 results for 'plsql'.

1) plsql - how do you output a plsql array via ref cursor
2) oracle - Testing AFTER INSERT Trigger
3) database-design - creating and populating table using pl/sql
4) oracle - Does ' /*+parallel(<Specific Table >,4)*/ ' have better impact on query performance in comparison with simple parallel hint '/*+parallel(4)*/'?
5) oracle - Procedure with "bind varibale" does not return the desired result set
6) oracle - Problem using 'Regular expression' in order to split characters of a column when there is no delimiter between them
7) oracle - Seperate value of a specific column with "," delimiter in Oracle using "Regular Expression"
8) oracle-11g-r2 - Query to find the "Number of days" a customer has an active card between a specified interval
9) oracle-11g-r2 - What is the main difference between '[[:space:]]' and '\s' in Oracle pl-sql regular expression?
10) oracle-11g-r2 - Error "ORA-12726:unmatched bracket in regular expression" while trying to separate a part of a string from other part
11) oracle - PL-SQL "LAST_VALUE" function does not give the desired result
12) oracle - Using 'Listagg' function and 'Regular Expression' to REVERSE the value of a specific column in Oracle
13) join - Are there better alternatives rather than using a "Full outer join" when it is not possible to use a "left or right join"?
14) oracle - PL/SQL - Drop User inside BeginEnd block
15) oracle - Oracle strong ref cursor with dynamic sql
16) oracle - How to pass data and loop in procedure Oracle
17) oracle - How to create index to improve performance of an aggregate function that creates a table in oracle
18) oracle - "Fire" a trigger to populate columns that are NOT NULL?
19) oracle - Variable Assignment and Usage in Oracle
20) oracle - Raise application error in a stored procedure when inputs contain keywords like 'delete' , 'insert','update'
21) oracle - creating stored procedure to populate empty table using pl/sql
22) oracle - Custom return type of a function in Oracle PL SQl
23) xml - Insert large xml file as as blob in oracle table
24) oracle - DB stored procedures: how do they help increase security in web systems?
25) oracle - What are the causes and solutions for mutating table errors?
26) oracle - SQL query to identify missing hinted indexes
27) trigger - PLSQL: BEFORE INSERT Trigger
28) oracle - oracle sql: How to not select select duplicate records from table
29) oracle - Loop through list of fields, check against lookup table
30) oracle - Package state not re-intialized on raise_application_error
31) oracle - Facing error 'invalid SQL statement' while working with cursor variables in PL/SQL
32) oracle - Commit and rollback in Oracle stored procedure
33) oracle - Set columns dinamically in UTL_FILE
34) oracle - How to call a stored procedure in an Oracle Scheduler job
35) oracle - Convert raw or hex value to signed 2's complement via Oracle SQL
36) oracle - Will an update in my trigger trigger itself? Oracle PLSQL
37) oracle - Facing error while trying to run dynamic pl/sql
38) oracle - Oracle Procedure alter pivoted data to unpivot and push into different destination
39) oracle - Incorrect :NEW syntax
40) oracle - Dividing a column into three columns
41) oracle - Is there any prevalent logging packages in PL/SQL similar to java and .Net counterparts
42) oracle - Combine multiple queries into single query
43) oracle - Selecting from random amount of tables with identical structure
44) oracle - Why can't we use strong ref cursor with dynamic SQL Statement?
45) oracle - Extract SDO_GEOMETRY line vertices into a nested table column (in a query resultset)
46) oracle - Toad for Oracle: Procedures, Packages, Job, and DBMS_SCHEDULER
47) oracle - Bind variable vs. string-concatenated variable
48) oracle - How do I execute a PL/SQL package from my database SQL> prompt?
49) oracle - Why can i not call COUNT on a varray column in a select statement using oracle
50) oracle - Return output of Oracle query