Skip to content

Tag: oracle

Fetch Substring in Oracle

I have a string as – V_TAG_B = utm_source=google_search&utm_medium=cpc&utm_term={Keyword}&utm_campaign=home-|-SBI-|-search I need to break this string into 4 small parts as – I need to do this because the string can be in any order such as utm_campaign coming first and utm_source is co…

How to select every Friday for the last six months?

I am working on the currency table. I need to get every Friday for the last six months. My query selects every day between two dates. Here my query OUTPUT OUTPUT(Should be) Thanks for helping. Answer Not clear if you are looking for Oracle or MS SQL-Server. In case you need it for Oracle you can use

Problem when trying to create a table on SQL DEVELOPER [closed]

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Stack Overflow. Closed 2 years ago. Improve this question I was trying to create a table on SQL Developer, and I had the error …

Oracle Database Object SQL query

In Oracle Database. There are two object tables SHOPS(S_NUM, S_NAME, TEL). And PRODUCTS(P_NUM, P_NAME, P_VAL, P_PRICE, SHOP_NUM). How to write in Oracle Object SQL language query to get how much there …

Sql syntax error while doing left outer Join in SQL

I’m using oracle database and trying to delete duplicate records from that. For the same I’ve written a below query but getting this error Its giving red indicator under outer keyword in Left outer join in query. Query: Answer Oracle does not permit JOINs in DELETE queries. This is clear if you lo…