How to remove replace part of a string?

I want to generate a report monthly

SQL ORACLE Creating a point column with using htf (hypertext functions)

Parsing XML containing name space

Oracle SQL function to return a value one or many

Selecting concatenated strings from IQueryable (oracle database)

Find the list of procedures / functions invoked from procedure in oracle

how to get FID of the user in oracle sql developer

By using order by clause,i'm not getting correct order. I need month wise dates

How to simplify the OR conditions in SQL statement?

Create a new table in Oracle SQL with data from another table

Oracle SQL: what is the cleanest way to refactor WITH...SELECT... into a function

Extract a file from Oracle server to S3 using Talend

Does Oracle JDBC driver work with Active Directory authentication?

Split Name String using regexp_substr

Sql query to Select data for same date

How to transpose multiple rows into multiple columns?

How to change format of table from row-oriented to columh-oriented

Summarize records every 30 minutes in Oracle SQL

Running Oracle NETCA/NETGMGR/DBCA on Docker for Windows

Sporadic long query execution in Oracle RDS

Update selected rows with selected results from another column

Query to find first,last and prior to last values

Many paralllel request with the same payload

oracle procedure ORA-00942

Split single row string into multiple rows by multi-chracter delimiter Oracle

Getting " Permission denied: connect" in JDeveloper

Oracle ADF Login (works sometimes and redirects to login page itself mostly)

update one table with data from another using derived key value

Trouble with PL/SQL statement

SQL Error: ORA-00904: invalid identifier during table creation

Inline View Qustion

Difference between count(1) and count(*) in oracle

Unable to connect to remote Oracle database using DBeaver

how to show a field in oracle reports at the bottom of the last page which is placed outside the border

Group by and distinct are not working in Oracle in Codeigniter

SQL Query optimization : is scalar subqueries killing the performance?

update else insert oracle procedure

Getting SQL Error: ORA-01847: day of month must be between 1 and last day of month when running my statment

A first chance exception of type 'OracleInternal.NotificationServices.ONSException' occurred in Oracle.ManagedDataAccess.dll


i am working on c# for desktop application. how can i redirect my page with login page from oracle database

Jasper report - how to pass date parameter as "day", "month", "year" part from java to jasper report using SQL

ORA-00933: SQL command not properly ended - Create View - Join

Restrict how many forms/reports users can generate with oracle reports

Sending an oracle EXEC statement to the DB through sqlalchemy

Oracles varchar2 performance issues with always using max length 4000

What Is Wrong with This Boolean Variable Decleration and Usage in PL/SQL Code?

Materialized view fast refresh - unexpected behavior in Oracle 12c

Oracle 12c in Docker

Oracle select with variables

Migrated to new server - Oracle DB connection broken

What is an efficient way to bulk copy data from a CLOB column to a VARCHAR2 column in Oracle

Set any param in PreparedStatement not working

Flatten a hierarchy query PLSQL not using subqueries and functions

Oracle return part of CLOB string

Is it possible to create one string from single characters?

Oracle table or view does not exist when creating FK to other user

Oracle query for first sunday

How to change the sequence order without dropping the sequence in oracle

PL SQL - Define Dynamically Global Cursor

Comparing two empty Strings in Oracle SQL

SQL ORACLE Creating a column name with using htf (hypertext functions)

Soap Webservice on Oracle 11.2: "Incorrect Input Doc/URL"

ORACLE SQL query from 3 tables using a latest date conditional

MERGE INTO Performance

Error: PLS-00707: unsupported construct or internal error [2603] in stored procedure

Create Database link to MS SQL Server on Oracle database

Oracle query for getting particular Date

SQL: How to find null values between different columns

USing pivot to convert rows to columns by keeping some rows constant

oracle SOA issue while installing

Good day All,please assist

The I/O & CPU work load are not stable cause the SP time costs are not similar and uniform

How to pivot below data in oracle?

Oracle query to get account details

Dynamic column creation with Oracle SQL

Crystal error ORA-01036 when previewing data in Crystal Reports

Selecting columns that have accented names using cx_Oracle

Using aliases leads to some invalid identifiers

SQL ORACLE Creating a border with using htf (hypertext functions)

Hibernate A different object with the same identifier value was already associated

Dynamically assign Min Max based on grouping of column in Oracle

Oracle and JDK 1.6.0_45

Oracle XMLQuery- Display comma separated list with two XML nodes

Using groovy: update timestamp oracle column

when insert data to a interval partitioned table why the partition can't created

oracle sql: collect aggregation

I have a varchar2 field which holds date. how can I check the format?

How can I get all the parent element by providing child element ID in oracle?

How to update a single row in an Interactive Grid?

Please optimize the below query to get the result as it is taking more time to get the records?

Trap and Stop the DDL Activity

Oracle query execution hangs and not getting result in java

Why I'm getting NoClassDefFoundError after update Apache Tomcat 7 to 9?

ORA-29280: invalid directory path returned when executing code in a pl/sql package works fine as an anonymous block

Converting SQL Server Query to Oracle

Checks for whether sysdate is equal to transaction date in Oracle

Oracle select dates that are not returned in the data set

Oracle 12c RAC : Start / Stop SCAN Listener one by one