I'm looking to create a package, already have a working procedure. Working on a function, step by step and I have encountered an ORA-06575: Package or function
I made a table called groups that has these columns client_id, course_name, group_number, day the primary key is (client_id, course_name) so each group num
I have a Data Guard with primary and standby database. But I have a problem, so my problem is like this. In primary if I query from v$archive_gap, I will get an
There are two tables given: 1) employee(eno,ename,basic,da,gross) da=basic*(5.0/100) gross = basic+da 2) sal_hist(eno, sys_dt, old_basic) How to write a
I working on an application where want to open oracle form but every time it shows message like this In order to access this application, you must install th
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production I am creating an Oracle job where I need to hit a procedure for every 30 minutes,
Version Information Weblogic 12.2.1.3, Forms [64 Bit] Version 12.2.1.3.0 I have installed Forms Builder only on my machine. I follow the proper configuration
the first thanks for your time. I am trying to insert data to the database by JPA(spring-boot), the project is using Oracle. Currently, Insert 5000 record, it t
I need to connect to remote oracle database using oci_connect(). After waiting for several minutes I get this error. $db = '(DESCRIPTION = (ADDRESS = (PR
I have to identify the records with check_in category of S1, T1 and P1 in the check-in-order and pivot the rest of the data until we hit the next category. I wa
A median is defined as a number separating the higher half of a data set from the lower half. Query the median of the Northern Latitudes (LAT_N) from STATION an
I'm trying to update two columns in an archaic Oracle database, but the query simply doesn't finish and nothing is updated. Any ideas to improve the query or so
I have a df which can have single/several rows per ID. If it has multiple rows, only 1 row is populated with a non-NA value for a column. Sometimes all rows are
I have two Oracle 12c (12.1.0.2.0) databases, one of which returns 'ok' for the following query (using SQL Developer 3.2.20.10), whereas the other results in OR
suddenly, my SQL Developer turned off, i can't add any connection to connect to my work remote databases, i tried to factory reset the views, uninstalled and re
Students and Grades. Students contains three columns ID, Name and Marks, Grades-(grade,min_mark,max_mark) Ketty gives Eve a task to generate a report containin
I need to statistics multiple columns,the following is my writing: with t_suml1 as(select id, date, sum(list1) result from table group by id,date), t_avgl
I'm currently creating an app in Oracle APEX and for some unknown to me reason while trying perform UPDATE/DELETE action by clicking on 'edit' button in the rep
I was interested in MT0's answer on this question using intervals and dates. I was working through trying to find a different way to answer the question and I s
I am trying to test an Oracle Stored Procedure in JMeter. I have already done the configuration to the DB successfully, but when I call the stored procedure and