ERROR : [FATAL] [DBT-05509] Failed to connect to the specified database (cdb21). CAUSE: OS Authentication might be disabled for this database (cdb21). ACT
I am using below query to build a materialized view. CREATE MATERIALIZED VIEW gcms_business_profile_mview BUILD IMMEDIATE REFRESH FAST WITH PRIM
TABLE: Column name Data type Constraints DEPARTMENT_ID NUMBER(5) PK DEPARTMENT_NAME VARCHAR2(25) NOT NULL LOCATION_ID VARCHAR2(15) I have tried this. But stil
Following SQL statement returns data when executed in Oracle SQL Developer: SELECT TC_GUID FROM TBLBUF WHERE TC_DEST = 'aaaaaaa' AND TC_STATE <= 20 but when
I have ~100,000 to 1,000,000 rows to insert into an Oracle18c database. I'm quite new with Oracle and this order of magnitude of data. I reckon there must be so
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