How to convert LONG to CLOB or to VARCHAR type in select statement
Hi, I need to convert LONG to CLOB or to VARCHAR type, to be able to apply either dbms_lob.substr() or just SUBSTR() function to this conversion result. Unfortunately Oracle function to_lob() converts LONG value in the column long_column to LOB values in the select list of a subquery in an INSERT...
Hi, I need to convert LONG to CLOB or to VARCHAR type, to be able to apply either dbms_lob.substr() or just SUBSTR() function to this conversion result. Unfortunately Oracle function to_lob() converts LONG value in the column long_column to LOB values in the select list of a subquery in an INSERT...
15 pts.
About Time
Hi Everyone, I need a PLSQL query inorder to keep track of TIME. Scenario : The Time Performed should be before the Other Time. Regards, Pet Software/Hardware used: OC
Hi Everyone, I need a PLSQL query inorder to keep track of TIME. Scenario : The Time Performed should be before the Other Time. Regards, Pet Software/Hardware used: OC
4 to 5 sql statements in procedures
I want to create 5 sql statements in one procedures which are performing diff tasks. can u provide the pl/sql PROC which can be include 5 sql statements.
I want to create 5 sql statements in one procedures which are performing diff tasks. can u provide the pl/sql PROC which can be include 5 sql statements.
Oracle PL/SQL Toad for Oracle-How to make editor generate a script for tables,views,packages so that the script can be searched
Hello, I am using "Toad for Oracle" and i am trying to find a way to search for certain words and numbers in the comments in scripts. I know you could use the create a script button and then control f to search for the words in the script. But is their a way to do it using a query or to create a...
Hello, I am using "Toad for Oracle" and i am trying to find a way to search for certain words and numbers in the comments in scripts. I know you could use the create a script button and then control f to search for the words in the script. But is their a way to do it using a query or to create a...
Oracle stored procedure error with PL/SQL
We wrote a stored procedure, where we are passing input as VARCHAR2. And passing 73 characters string as input. Till here its fine. After giving few extra characters above this, it’s giving the error: ORA-06502: PL/SQL: numeric or value error ORA-06512: at "stored procedure name", line 114...
We wrote a stored procedure, where we are passing input as VARCHAR2. And passing 73 characters string as input. Till here its fine. After giving few extra characters above this, it’s giving the error: ORA-06502: PL/SQL: numeric or value error ORA-06512: at "stored procedure name", line 114...
calling reports in pl/sql code
how to call reports 6i report from pl/sql code procedure in pdf format
how to call reports 6i report from pl/sql code procedure in pdf format
BULK COLLECT and FORALL in PL/SQL
How do I update multiple columns in a table using the BULK COLLECT... FORALL methods in PL/SQL.
How do I update multiple columns in a table using the BULK COLLECT... FORALL methods in PL/SQL.
Convert Oracle code to Microsoft SQL code
I've been given an Oracle DB that has some triggers and "LOAD DATA" jobs. Is there a tool/utility to convert the triggers/loads from PL/SQL into T-SQL?
I've been given an Oracle DB that has some triggers and "LOAD DATA" jobs. Is there a tool/utility to convert the triggers/loads from PL/SQL into T-SQL?
Invalid objects after upgrade from 8.1.7.4 to 10G
for the following procedure within a package: PROCEDURE GET_ALL_REGIONS(rs_REGION_LIST OUT r_REGION_LIST, Vrc2_err_msg OUT VARCHAR) IS BEGIN OPEN rs_REGION_LIST FOR SELECT DISTINCT(PRS_REGION) INTO r_REGION_LIST FROM SET_PARISH_RFT; Vrc2_err_msg:=NULL; RETURN; ...
for the following procedure within a package: PROCEDURE GET_ALL_REGIONS(rs_REGION_LIST OUT r_REGION_LIST, Vrc2_err_msg OUT VARCHAR) IS BEGIN OPEN rs_REGION_LIST FOR SELECT DISTINCT(PRS_REGION) INTO r_REGION_LIST FROM SET_PARISH_RFT; Vrc2_err_msg:=NULL; RETURN; ...
What is the difference between software package in SQL and PL/SQL
why is the need of psql when the sql is already avaliable.
why is the need of psql when the sql is already avaliable.
NEED HELP to DETERMINE STEPS to TAKE when going from 9i to 10g in terms of plsql best practices as well as known issues to watchout for
Need Expert Help to Determine Steps to Take: When going from 9i to 10g in terms of: _______________________________ 1) plsql best practices for both 9i and 10g that are specific and could be measured against 2) known issues to watchout for in terms of 10g overall, 10g prominent bugs/issues 3)...
Need Expert Help to Determine Steps to Take: When going from 9i to 10g in terms of: _______________________________ 1) plsql best practices for both 9i and 10g that are specific and could be measured against 2) known issues to watchout for in terms of 10g overall, 10g prominent bugs/issues 3)...
DDL in PL/SQL procedure
I have a question, i create drop and create a table in pl/sql proc using execute immediate. Later I declare a ref cursor, to process data from table created. Problem is the procedure executes correctly, but after execution procedure becomes invalid. How can i solve this issue. Thanks in advance.
I have a question, i create drop and create a table in pl/sql proc using execute immediate. Later I declare a ref cursor, to process data from table created. Problem is the procedure executes correctly, but after execution procedure becomes invalid. How can i solve this issue. Thanks in advance.
Formatting PL/SQL code in SQL DEVELOPER
Hi Experts, I would like to know some keyboard shortcuts and clever formating on PL/SQL codes in SQL developer Pls hlp me out with some hints for this.. thanks n advance
Hi Experts, I would like to know some keyboard shortcuts and clever formating on PL/SQL codes in SQL developer Pls hlp me out with some hints for this.. thanks n advance
Inserting 50000 rows using FORALL statement
How can we insert 50000 rows by using FORALL,please give me entire code?
How can we insert 50000 rows by using FORALL,please give me entire code?
PL/SQL
Hi Experts, I would like to mentione here i was trying to test one package and found the package has a procedure named SET() which hav UPDATE on Report table and INSERT on A_R table in same transaction Both the above mentioned tables hav a tim_upt column which s given as systimestamp and...
Hi Experts, I would like to mentione here i was trying to test one package and found the package has a procedure named SET() which hav UPDATE on Report table and INSERT on A_R table in same transaction Both the above mentioned tables hav a tim_upt column which s given as systimestamp and...
PL/SQL: How to check address NOT NULL but can take -(hyphen) instead being NULL
Hi Experts, How can we make a check on an attribute not null but can take - rather I have address 3 which can't take null instead - would be fine how this can be check n PL/SQL procedure I can check IF address 3 IS NULL THEN ... END IF But i want to test with test case tat it can't take...
Hi Experts, How can we make a check on an attribute not null but can take - rather I have address 3 which can't take null instead - would be fine how this can be check n PL/SQL procedure I can check IF address 3 IS NULL THEN ... END IF But i want to test with test case tat it can't take...
PL/SQL - Attribute to test not null and can take specific value instead
Hi Experts, How can we make a check on an attribute not null but can take - rather I have address 3 which can't take null instead - would be fine how this can be check n PL/SQL procedure
Hi Experts, How can we make a check on an attribute not null but can take - rather I have address 3 which can't take null instead - would be fine how this can be check n PL/SQL procedure
PL/SQL - How to make a check whether the attribute is positive or zero
Hi Experts, How to make a check on attribute(NUMBER) is positive or zero?
Hi Experts, How to make a check on attribute(NUMBER) is positive or zero?
