Top "Oracle" questions

Oracle sql return true if exists question

How do I check if a particular element exists in a table - how can I return true or false? …

sql oracle if-statement exists

Connection timeout for DriverManager getConnection

I am trying to connect to DB using the standard JDBC way connection = DriverManager.getConnection(url, username, password); Is there …

java oracle jdbc database-connection

What is the difference between Non-Repeatable Read and Phantom Read?

What is the difference between non-repeatable read and phantom read? I have read the Isolation (database systems) article from Wikipedia, …

database oracle transactions isolation-level transaction-isolation

oracle sql date not later than today

I need to display some data if it's a - new data - updated data let's say, I will be …

sql oracle logic

Displaying the hex value of a string from a oracle varchar2?

We are having problems with text that is encoded in some different ways but kept in a single column in …

oracle unicode utf-8 turkish ojdbc

dbms_scheduler.run_job('jobName) fails to run

I'm trying to run a scheduled job manually, the job looksa like this DBMS_SCHEDULER.CREATE_JOB ( job_name => …

oracle stored-procedures plsql dbms-scheduler

MyBatis Insert List values

Mapper.xml (Mapper xml file) <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//…

java oracle mybatis

Concatenate and group multiple rows in Oracle

Possible Duplicate: how to retrieve two columns data in A,B format in Oracle Suppose I have a table like …

sql oracle concatenation grouping group-concat

How to document a database

(Note: I realize this is close to How do you document your database structure? , but I don't think it's identical.) …

sql oracle documentation

How to subtract 2 dates in oracle to get the result in hour and minute

I want to subtract 2 dates and represent the result in hour and minute in one decimal figure. I have the …

sql oracle date-arithmetic