Most voted "pl-sql" questions
PL/SQL (acronym for Procedural Language/Structured Query Language) is an extension of the standard SQL language for Oracle DBMS from Oracle Corporation.
Learn more…277 questions
Sort by count of
-
0
votes1
answer43
viewsthe identifier 'DMBS_OUTPUT.CHARARR' must be declared plsql oracle
I am writing the following plsql code: declare tab dmbs_output.chararr; qtlines number default 3; res varchar2(100) default null; begin dbms_output.get_lines(tab, qtlines); dbms_output.put_line(…
-
0
votes0
answers35
viewsReturn names that have no registered workshop
Good afternoon, I would like a help to return names that do not contain the workshop'2' in the registered case. The way I rode, it brings me different from (''), I need that besides different, bring…
-
0
votes0
answers25
viewsQuestion about filter with dates
I’m a beginner in SQL, and I’m working on a project on Oracle. I got stuck in a situation that theoretically would be simple to solve, but I don’t succeed. They can help me? Below follows the code…
-
0
votes0
answers28
viewsTrigger with mutant error even using Pragma Autonomous_transaction;
I’m a beginner and I’m having trouble solving a simple problem: I created Trigger below: AFTER INSERT OR UPDATE ON CARRO FOR EACH ROW DECLARE Pragma Autonomous_Transaction; V_REFERENCIA INT; BEGIN…
-
-1
votes1
answer482
views -
-1
votes1
answer2206
viewsHow to Identify and Fix 00302 Error in Oracle?
How can I fix an error of this nature (ERROR 00302) and how to know which line is the error in oracle SQL Developer? Error(16,6): PL/SQL: Statement ignored Error(16,52): PLS-00302: component…
-
-1
votes2
answers1365
views"ORA-01417: a table may be Outer joined to at Most one other table"
I’m riding a select and I came across the following mistake: ORA-01417: a table may be Outer joined to at Most one other table SELECT A.SEQPESSOA, A.NUMERONF, A.NROEMPRESA, A.SEQPRODUTO,…
-
-1
votes1
answer88
viewsREGEX - How do I search for expressions that DO NOT contain a specific part?
I’m working with PL/SQL. Through REGEX, how do I find all expressions that are different from: <cod_orgao_destino>9577</cod_orgao_destino> Thank you!…
-
-1
votes2
answers849
viewsCondition within the WHERE clause
Good afternoon ! I have a task to perform a select, but the parameters are passed as variables and I need to treat the input of one of these variables with the following logic: if &CT is not…
-
-1
votes1
answer493
viewsPLSQL - Procedure for Password Encryption
I searched on the internet a precedent for encrypt the users password, however I only found functions. There is how to generate a Procedure to carry out this process? CREATE OR REPLACE FUNCTION…
-
-1
votes1
answer54
viewsError with Trigger and exception
The detail is that I am trying to insert a post and fire a Rigger to save the message according to whether or not the post is entered. The mistake is I can’t capture the exception. When I enter…
pl-sqlasked 6 years, 5 months ago André Nascimento 1,258 -
-1
votes1
answer325
viewsOracle - Alias in Case
How can I put an alias in the column name in a CASE? CASE atu.cod_situacao_matricula "Alias" WHEN 2 THEN 'Matriculado' CASE atu.cod_situacao_matricula as Alias WHEN 2 THEN 'Matriculado' Both give…
-
-1
votes1
answer263
viewsRun Automatic Update - Oracle
I often run a Update on Oracle to change the status in my database, but I would like this update to run automatically, once a day. UPDATE inativa_produto set compras = 'N', estoque = 'N',…
-
-1
votes1
answer81
views -
-1
votes1
answer1044
viewsORA-01722: invalid number
Help me with this error please, I wanted to understand why it is happening when trying to recover the ID of the enrollment field, when selecting the enrollment field in my select list in my form.…
-
-1
votes1
answer40
views -
-1
votes1
answer20
viewsQuery via dblink is giving error ORA-02022
Good evening, I am making a query by PL/SQL in a postgres database, connected by a dblink, in postgres the view is executed correctly, but when I consult through dbllink is giving the error…
-
-1
votes1
answer121
viewsAnonymized block help with IF in PL/SQL
I am studying PL/SQL on my own account and I am having a lot of difficulty, I would like to tell you how I can improve the code below. I’m using the logic of wanting to pull and count every time the…
pl-sqlasked 4 years, 6 months ago beta_carlin 1 -
-1
votes1
answer53
viewsOracle - Error : ORA-24263: Certificate , how to treat?
Sending https via Oracle Version Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production PL/SQL Release 12.2.0.1.0 - Production "CORE 12.2.0.1.0 Production" TNS for Linux: Version…
-
-1
votes1
answer21
viewsYou can do a PIVOT using SUBSTR
Hello everybody all good? I’m trying to do a PIVOT on oracle 11 by only getting the first character of a STRING. CREATE TABLE T_ESTOQUE( CD_ENDERECO VARCHAR(15), CD_PRODUTO VARCHAR(20), QT_ESTOQUE…
-
-1
votes1
answer82
viewsCount a pl/sql column
I am trying to count a column (minutes) as it is in the query: SELECT distinct b.nr_atendimento ,to_char(dt_prescricao,'dd/mm/yyyy hh24:mi:ss') Prescricao ,to_char(a.dt_atualizacao,'dd/mm/yyyy…
-
-2
votes1
answer37
viewsI compile a package and give errors. Error location is wrong
After compiling a package, comes 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"…
-
-2
votes1
answer125
viewsDaily count - PL/SQL
Good morning! In the example sent we have a number of attendance, the date of arrival and the date of departure of the patient; and the daily count. In the daily count I am considering only the…
-
-2
votes1
answer66
viewsDoubt with Concat on Oracle
I have a problem in exporting data to Excel, the number recorded in the database and very large generating several strange characters in the conversion that Excel tries to do, so I need to send it…
-
-2
votes1
answer42
viewsTrigger with update
I have a table emp with salary, id, and job and added a new column value in this column. I will update when the employee receives a raise. I created a support table where I have id , salary,date and…
pl-sqlasked 5 years, 12 months ago Claudio Reis 1 -
-4
votes1
answer50
viewsSelecting a data in a table that is not with you in another
Hello, I’d like to know how you belt a field that you don’t have on another table. logically would be so "selects document code in table x where document code does not exist in table y ";
-
-5
votes2
answers870
viewsWhat are the differences between a PL/SQL programmer and an Oracle DBA?
Could someone explain to me the differences between the programmer PL/SQL and the DBA Oracle? I know there are many differences, but I’m not sure how to specify them. I have some doubts too... For…