Questions tagged as 'oracle'

Tagged questions
1
answer

Function in PHP returning query in oracle database

I'm trying to create a function in php that brings information from my Oracle database, but the function does not return any value. This function is meant to return some user data. The function is as follows: <?php function fn_valida_pe...
asked by 04.02.2016 / 19:14
1
answer

How to select N records in a select in Oracle plSQL? [closed]

I have 3 tbs, I do the following get the id of tb1 in common with tb2 and tb3 (id), then compare if field 1 of tb1 (LENGTH) is greater than field 1 of t2, in tbs 1 and 2 there are several ids of tb3, (it is necessary to go through tbs 2 and 3 al...
asked by 08.08.2018 / 21:18
1
answer

CONDITION WITHIN 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 null, then I add in the condition of select the...
asked by 20.09.2018 / 18:55
1
answer

How to convert sysdate to milliseconds in Oracle?

How do I convert sysdate to milisegundos directly into Oracle? I need to give the same result of the code below in java, but directly in query : String s=df.format(Calendar.getInstance()); java.util.Date parsedUtilDate = df.p...
asked by 23.02.2017 / 21:49
1
answer

Using subselect in oracle. Why does the error occur?

I'm trying to use this code below, but oracle returns me the following error:    ORA-00907: right parenthesis not found   00907. 00000 - "missing right parenthesis"   * Cause:   * Action:   Error on line: 30 Column: 10 I can not identify...
asked by 21.02.2017 / 15:42
1
answer

How not to select rows with values between an informed list of values

Instead of using the logical operator of != , I'd like to use a code that does the query by disregarding a list of values such as In only the reverse. Select from teste where teste1 (código) ('x','y','a','g') I'm using...
asked by 20.02.2017 / 15:35
2
answers

Error installing jdbc oracle in eclipse

I'm finding impediments to installing oracle jdbc. Screen Errormessage:  Errorreadingfile  C:\Users\alex.jose.silva.m2\repository\com\oracle\ojdbc14\10.2.0.3.0\ojdbc14-10.2.0.3.0.jar  C:\Users\alex.jose.silva.m2\repository\com\oracle\ojdbc...
asked by 16.01.2018 / 16:18
1
answer

PLSQL - Procedure to Encrypt Password

I searched the internet for a procedure to encrypt users password , however I only found functions . Is there a way to generate a procedure to perform this process? CREATE OR REPLACE FUNCTION MD5(VALOR VARCHAR) RETURN VARCHAR2 IS...
asked by 27.09.2018 / 02:59
1
answer

Access oracle database remotely

Is there any way to access, or at least import / create my database in some workspace, or oracle server (free)? So that it can be accessed remotely. If yes, how could I do this "access"?     
asked by 07.09.2017 / 22:46
1
answer

Creating View with Records Limit

I want to create a view that should only return a maximum of% with% registrations, regardless of the applied selection clauses . That is, whatever filter you apply, the number of rows should always be X . (with X does not se...
asked by 03.10.2016 / 18:11