I'm writing a Python script to fetch some values from Oracle, but by the middle I have to set an ID to a package so it can create the corresponding view with th
I have developed a .Net C# based website, which is dependent mostly on Oracle database. To access the DB I have been using Oracle ODAC 11G. (Oracle.DataAccess.d
So i have a query that i would like to execute through a stored procedure and export the output of the query to a CSV file. But only the last column name is not
I need to add a validation in the following way. There's a drop-down list with two attributes(let them be A1 & A2) and an Input Text box. I need to let the
I'm working on some Oracle DB problem. Is there any possibility, to check if table or column exists, before I want to modify it? If it doesn'
I'm working on some Oracle DB problem. Is there any possibility, to check if table or column exists, before I want to modify it? If it doesn'
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