Questions tagged as 'oracle'

Tagged questions
1
answer

IF condition within an Oracle SELECT [duplicate]

There are other questions in this context, but I am lazy on the subject and I do not understand. With this, I need help. I have SELECT for searching data in a ORACLE database, however I need to make a IF condition withi...
asked by 28.02.2017 / 22:25
2
answers

Storage of files, in database or disk? [duplicate]

I'm developing an intranet system, with a file storage module (exclusively PDF). What do you tell me about the storage location, save to disk on the server or database? Remembering that it is an intranet. The server is on the same networ...
asked by 23.06.2017 / 19:53
1
answer

Doubt in select with group by and count?

I'm doing SQL in 2 tables in Oracle and would like to group the information according to the job code and also count how many people are in that charge. I'm using the following SQL : select f.numemp, f.numcad, f.nomfu...
asked by 03.05.2017 / 20:55
1
answer

How do I prepare the packages in oracle?

How do I make a query (PL / SQL) to list a specific Package in the database (Oracle)?     
asked by 07.11.2016 / 14:08
2
answers

You can save multiple values in a single bank field

I declare the field in the database like this: descricao VARCHAR2(5)not null, You can, for example, save 1 , 2 , 3 , 4 a single record) in the descricao field, where each of these values refers to a specific thing.     
asked by 16.10.2016 / 03:13
1
answer

Doubts with "pivot" ORACLE

I would like to know how I can put the fields CODE_PROCESSO, PRODUCT_NAME, and APPROVED_USO in the main select to show in my query SELECT CODIGO_PROCESSO, MAX (DECODE (tipo_arquivo, 'BT', caminho_arquivo)) ArquivoBT, MAX (DECODE (tipo_arquivo...
asked by 02.12.2016 / 15:46
2
answers

SELECT INSERT in Oracle using sequence nextval and group by

Good morning, guys! I'm trying to do a select insert in Oracle using a SEQUENCE in the id, but it's giving error on account of a group by in select. Dry my SQL: INSERT INTO SUP_T(ID, DESCRICAO) SELECT SEQ_SUP_T.NEXTVAL,TIPO.TIPO F...
asked by 04.07.2016 / 13:59
1
answer

Oracle SQL Error Invalid Number

I have the following query, which shows me date and time, recorded as default sysdate of Oracle: SELECT TO_CHAR(DATA, 'DD/MM/YYYY hh24:mi:SS') D1, TO_CHAR(DATA_FIM, 'DD/MM/YYYY hh24:mi:SS') D2 FROM PCN_ROMANEIO_CHECK W...
asked by 26.08.2016 / 16:11
1
answer

Tables are not shown in Oracle SQL Developer

I have multiple connections configured in TNSNAMES.ORA , and for some I can not see any tables if they expand the folder. The user I am connecting to has access because I make queries and insertions normally. I found a tip on the intern...
asked by 09.12.2015 / 17:34
1
answer

How to do select picking the record that has the maximum value of a field?

I'm doing a select that is looking for records that meet certain conditions and then you should get only the record that has the maximum value of a given field. You're like this: SELECT VP.VAL_PREVISTO FROM TB_META M INNER JOIN...
asked by 31.07.2015 / 15:28