Questions tagged as 'oracle11g'

1
answer

How to create a sub-select in oracle in a table with composite key?

The table has composite primary key, and the fields are a date (ID_DEPURACAO) and a number (SEQ_DEPURACAO). What I want to do is a sub-select that takes only data that is larger than a certain date and has sequences from a certain number....
asked by 28.10.2016 / 13:44
1
answer

Dynamic table in a view in oracle

Good afternoon, friends. I need to create a view in oracle, which contains the table in the dynamic select. Example: Select * from usina2016; This 2016 from the end of the table name, I have to get sysdate from the current year and concatenat...
asked by 16.08.2016 / 22:33
1
answer

How to import Dump with 2 schemas for different dataspaces

I have a Dump with which expdp was made with 2 schemas. I would like to impdp remap tablespace to 2 new tablespaces . My parfile current: userid=dba/dba@streetfight dumpfile=expdp-ryueken-15072016.dmp lo...
asked by 15.07.2016 / 14:18
1
answer

Execute stored procedure in oracle database in PHP

I have procedure " example1 " which receives 3 input parameters and none output, how do I execute it in PHP . That would be the case. EXEC "exemplo1"('para1','para1','para3'); $sql = 'EXECUTE "PORTAL_importaXml"'. "(?,?,?...
asked by 03.09.2018 / 21:42
1
answer

How to identify and correct error 00302 in Oracle? [closed]

How can I correct an error of this nature (ERROR 00302) and how to know the line in which the error is in Oracle SQL Developer? Error(16,6): PL/SQL: Statement ignored Error(16,52): PLS-00302: component 'NOME_PESSOA' must be declared Error(17,6...
asked by 19.07.2016 / 20:23
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

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

Add and divide columns oracle

I have 4 columns. I want to do the subtraction process in 3 and divide by the fourth. How do I do this in Oracle DB? COLUNA1 - COLUNA2 - COLUNA3 = RESULTADO; RESULTADO / COLUNA4 = COLUNA5     
asked by 20.08.2018 / 13:46
1
answer

How to insert date and time in oracle? via c #

I'm developing a desktop application and it was working fine until the time I tried to insert the date and time generated by C # into a table in oracle. Can someone teach me the query to insert date into this format: 21/07/2018 12:54:35: (dd/m...
asked by 11.05.2018 / 16:12