Strip Tags HTML
Is there any function to ignore html tags when conducting searches in a oracle table?
Is there any function to ignore html tags when conducting searches in a oracle table?
45 pts.
insert and updat remote table
am using a trigger to sync a remote table every time there is an update or insert on the local table. The columns are user-type object. The tirgger can not insert or update on the remote table. I get the following error: CUSTOMERS Table : ORA-22804: remote operations not permitted on object...
am using a trigger to sync a remote table every time there is an update or insert on the local table. The columns are user-type object. The tirgger can not insert or update on the remote table. I get the following error: CUSTOMERS Table : ORA-22804: remote operations not permitted on object...
Oracle table column names starting with a number
Hello, I just finished creating MANY tables that have column names starting with a number. I didn’t realize it was an issue until I started trying to select data from my tables using the column names in the where clause. Inserts work. Selects without where work. Is there any way to...
Hello, I just finished creating MANY tables that have column names starting with a number. I didn’t realize it was an issue until I started trying to select data from my tables using the column names in the where clause. Inserts work. Selects without where work. Is there any way to...
How to capture error stack when using forall in PL/SQL?
How do you capture all the errors in an error stack when using forall/bulk processing within PL/SQL? This is the error stack: ORA-12801: error signaled in parallel query server P000 ORA-01722: invalid number The only error captured in PL/SQL is the first error message but the second is actually...
How do you capture all the errors in an error stack when using forall/bulk processing within PL/SQL? This is the error stack: ORA-12801: error signaled in parallel query server P000 ORA-01722: invalid number The only error captured in PL/SQL is the first error message but the second is actually...
my question
How to find the repeating charactar or letter in a string like 'information' in pl/sql or sql .
How to find the repeating charactar or letter in a string like 'information' in pl/sql or sql .
