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
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
github-enterprise