Questions tagged as 'oracle'

Tagged questions
2
answers

Is there a similar clause similar to LIMIT in PL / SQL

I'm using PL / SQL and would like to know if you have any clause or sql script that is similar to the sql LIMIT clause, I've been searching here and found rownum < = X, but does not meet what I want to do. I'll try to explain SELECT select...
asked by 23.02.2018 / 16:04
2
answers

How to pass a Char to the bank?

How do I get a Char to the Bank? Error Exception in thread "main" java.sql.SQLException: ORA-12899: valor muito grande para a coluna "SYSTEM"."USUARIO"."TP_SEXO" (real: 2, máximo: 1) at oracle.jdbc.driver.T4CTTIoer.processError(...
asked by 16.10.2015 / 14:09
3
answers

How to select the year in PLSQL?

I have a table of data for company officials. I have to show who completed a year of work at the company. The data type for the yearAdmission field: DATE (dd / mm / yy)     
asked by 07.02.2018 / 21:28
1
answer

Error creating a simple table in Oracle SQL Developer

I'm having trouble creating the following table: CREATE TABLE T_AM_OME_ADVOGADO ( cd_pessoa NUMBER (8) NOT NULL , nr_oab NUMBER (8) NOT NULL , nr_cpf NUMBER (11) NOT NULL , nr_rg CHAR (10) NOT NULL , ds_email VARCHAR2 (128...
asked by 18.08.2016 / 21:18
3
answers

Pick up number after the comma

Working with plsql I am dividing two numbers, and would like to receive only what comes after the comma. Ex: 7.89111. I just need the number 89111.     
asked by 26.10.2015 / 15:35
1
answer

How to Pass Values to Procedure Parameters - PL / SQL

I asked the management company of our system to change the code of some of the neighborhoods of the system, it made that change, now I need to change the code of other districts that are in the system, I know that change is delicate and that the...
asked by 09.04.2014 / 17:19
1
answer

Oracle- Variable without data

I have a problem and a question at the same time, I made a function to view billed requests and declare a function variable like this: select filsaida into v_loja from mov_itped where pedido= p_pedido and status <> 6; end ; When y...
asked by 28.06.2018 / 20:07
1
answer

Fatal error: Call to undefined function oci_connect ()

Error connecting to Oracle database. Here is the code in PHP: <?php $ora_bd = "(DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP) (HOST=192.168.0.249)(PORT=1521) ) ) (CONNECT_DATA=(SERVICE_NAM...
asked by 12.02.2018 / 17:38
3
answers

Select the dates below a certain year

How can I create select to show only the employees of a company that have been admitted to it before a given year? The type yearAdmission is date ie: dd-mm-AA     
asked by 07.02.2018 / 20:31
2
answers

Trigger to retrieve Last Record Inserted into table in PL-SQL

I have a trigger that after inserting a new user in the table tFuncionario I have to fill another table tPlanoSaude with the data of the official. Employee table HealthPlantable TriggersCodeCREATEORREPLACETRIGGERINSERTFUNCIONARIOBEFOREINS...
asked by 08.02.2018 / 21:02