Questions tagged as 'plsql'

I have to make an insert in SQL Server. I have tried the following, but I do not know if it will be fine, at first glance it gives me a fault near the IF and the THEN , but I do not know why. I imagine it will be for the AND...

   ORA-01841: the (complete) value of the year should be between -4713 and +9999, and not   must be equal to 0   ORA-06512: online 8 DECLARE LIMITE DATE := '30-01-2018'; CONTADOR NUMBER(2) := 0; ACTUAL DATE := SYSDATE; BEGIN LOOP...

Does anyone know any way to search for words within the oracle developer ??? to search for matches within the database I need to find where the functions or procedures could make SELECTS to a table     

GOOD AFTERNOON I AM MAKING A SUB-CONSULTATION OF A TABLE IN ORACLE TO BRING THE BENEFICIARIES OF A QUOTE BY MEANS OF A FOREACH I NEED ON THE PART OF THE TABLE TO SHOW ONLY ONE SIDE THE QUOTE, AS IT CAN BE OBSERVED IN THE PICTURE H...