Questions tagged as 'oracle'

Tagged questions
1
answer

Sequence in ORACLE, such as returning to a previous value or modifying its current value

Let's say I have this sequence CREATE SEQUENCE "NOMBRE_DB"."MI_SECUENCIA" MINVALUE 0 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER NOCYCLE ; And we want to check your status to alter its value     
asked by 17.08.2018 / 19:33
0
answers

Show image in apex saved in the server's file system

I have an apex application with which I upload images to the linux file system (where apex runs) in the / my_files folder. Now I would like to show those images in an interactive report. for which I make the following query select "ROWID",...
asked by 13.08.2018 / 23:28
0
answers

OVM manager can not launch console

I am using oracle vm manager 3.4.4 on oracle linux 7.5 but the web interface does not work and when I want to open the web console it returns the following error: novnc ready native websockets canvas rendering error, after a certain time waiting...
asked by 14.08.2018 / 05:03
1
answer

export to ovf or ova format Ovm manager 3.4.4 from the cli

I am trying to export a virtual machine in ova or ovf format from oracle VM Manager 3.4.4 I use the following command: ssh admin@localhost -p 10000 "exportVirtualAppliance REPOSITORIO name=myvm \vms=0004fb000006000061d443224aee4fdf" But th...
asked by 14.08.2018 / 16:28
1
answer

Use of uninitialized value $ _ in pattern match (m //) at cursor.pl line 5

I have this Perl script: #!/usr/bin/perl use strict; use warnings; while () { if (/^PARSING IN CURSOR/../END OF STMT/) { if (/^PARSING IN CURSOR/) { s/^PARSING IN CURSOR \#//; s/ [a-z]+=/!/g; s/\...
asked by 09.08.2018 / 03:21
1
answer

How to get the percentage in SQL

The amounts that I handle to make the query are: (3427.2*100)/3716041.16 = 108427.9049953314659197012138188608776844 How to get it done that throws the percentage in whole because how will the system know that the percentage is 108% SELEC...
asked by 09.08.2018 / 18:55
2
answers

how can I make a query with only the month and date in SQL

As I can do a query in the BD only taking the month and the year of a date, I was trying this but it marks that the month is not valid SELECT * FROM CL_RP_COBRANZA_TNR WHERE TO_DATE(FECHA_VENCIMIENTO,'MM/RRRR') = TO_DATE('10/2015...
asked by 07.08.2018 / 15:47
2
answers

PL / SQL Check the value of a column ending with '_' or '%'

I have this table with random values and I want to select only those that end with "_" or "%" in the flavor column using the option "ESCAPE". I have tried this way but it also brings me those that have "_" in the middle of the value....
asked by 03.08.2018 / 09:03
0
answers

Oracle - Help with query with a date field and two different types of events to display a single row

I have a table that registers some events of entry and exit, it keeps the date with time, the id of the user and the type of event. TABLE: TABLA_ID | USUARIO_ID | FECHA_HORA | TIPO_EVENTO 1 | 1 | 2018-08-01 18:...
asked by 06.08.2018 / 21:35
0
answers

Insert massive random with Bulk collect and forall in oracle pl / sql

for simulation questions I am trying a user table with at least 6 million records more quickly using bulk collect and forall, the codes that adapt this worked only once and then I did not understand why it stopped working. here I leave the code...
asked by 31.07.2018 / 23:48