I have an Oracle database from which I am selecting a table from a remote postgres database, pg. The column mydate is of type date. select to_char(mydate,'mm-d
I want to capture truncate and drop statements on one table. In some google searches i got that it's impossible to execute: audit truncate, drop on schema.tab
There is a table and its data looks like this: year month v1 v2 2017 1 2 3 2017 2 4 5 ... .. .. .. 2017 12 9 3 2018 1 1 3 2018
How could I edit the information on popup window in NetSuite ? Like this photo, I wanna to show some other information in this popup window . enter image descri
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