Top "Oracle" questions

Return multiple values from PL/SQL Function

I need to try and find a free seat on a plane, and then reserve that seat. I need to …

oracle plsql sql-function

Remove last character from string in sql plus

I'm trying to remove the last character from a column output in sql plus. The length of the column entries …

sql oracle sqlplus

how to convert date into month number?

I have a column Month in my table. The month name and date are stored in this month column like …

sql oracle sqldatetime

Oracle: how to "group by" over a range?

If I have a table like this: pkey age ---- --- 1 8 2 5 3 12 4 12 5 22 I can "group by" to get a count of …

sql oracle plsql oracle10g

How to parse comma delimited string in PL/SQL?

I have a comma delimited string in a PL/SQL script (e.g. data:= 'a,b,c,d,e'), that …

oracle stored-procedures plsql plsqldeveloper

MyBatis Batch Insert/Update For Oracle

I've recently started learning to use myBatis.I am now facing such a scenario, I need to constantly fetch a …

java sql oracle mybatis

Using the DISTINCT keyword causes this error: not a SELECTed expression

I have a query that looks something like this: SELECT DISTINCT share.rooms FROM Shares share left join share.rooms.…

sql oracle hibernate oracle11g

oracle convert unix epoch time to date

The context is that there is an existing application in our product which generates and sends the EPOCH number to …

oracle datetime unix date-format epoch

How should I store a GUID in Oracle?

I am coming from the SQL server world where we had uniqueidentifier. Is there an equivalent in oracle? This column …

database oracle guid

How to change schema name?

I have created a user: CREATE USER gds_map IDENTIFIED BY gds_map; And now I need to change a …

oracle plsql schema oracle11gr2