Questions tagged as 'pl-sql'

1
answer

I compile a package and it gives errors. Error location is wrong

After compiling a package, you get this error message:    249/36 PLS-00103: Encountered the symbol "TS_ODO" when expecting one   of the following:: =. (@%; The symbol ":=" was substituted   for "TS_ODO" to continue.       250/34 PLS-00103: E...
asked by 10.12.2015 / 13:17
1
answer

Daily Count - PL / SQL

Good morning! In the example we have a service number, the date of entry and the date of leaving the patient; and the daily count. In the daily count I am only considering the period from 07/01/2017 to 07/31/2017, counting even the first day. Th...
asked by 07.11.2018 / 11:47
1
answer

Selecting a data in a table that is not with you in another [closed]

Hello, I'd like to know how to draw a field that I do not have on another table. logically would be like this "selects code of the document in table x where the code of the document does not exist in table and";     
asked by 13.08.2017 / 16:05
2
answers

What are the differences between a PL / SQL programmer and an Oracle DBA? [closed]

Can one explain the differences between the PL / SQL programmer and the Oracle DBA ? I know there are many differences, but I'm not sure how to specify them. I have some doubts too ... For example:    Can a DBA program Procedures...
asked by 04.09.2017 / 16:31