Top "Oracle" questions

The order of a SQL Select statement without Order By clause

As I know, from the relational database theory, a select statement without an order by clause should be considered to …

sql-server oracle select sql-order-by

Column headings keep appearing throughout Oracle output

After ever 10 lines, my column headers reappear in my Oracle output. Is there something about my code or some kind …

oracle sqlplus

How to get information about compile error in Oracle/TOAD

I'm using TOAD to develop a stored function in an Oracle database. When I click the "run as script" button …

oracle toad

Oracle alter table insufficient privileges

I have just installed oracle 12c and then i am trying to grant user various rights. I am logged in …

sql oracle permissions privileges database-administration

pragma autonomous_transaction in a trigger

I have written a trigger on one table which deletes data from other table upon a condition. The trigger has …

oracle plsql triggers oracle11g plsqldeveloper

Displaying CLOB Column with 4000+ characters

I have this CLOB column and I need to display it using a select statement. I used DBMS_LOB.SUBSTR …

oracle clob

Date type without time in Oracle

In Oracle 10g I got a problem when using DATE type in my table. I just want my DATE field …

oracle datetime date oracle10g

Constraint Violation Exception ORA-00001

I am using Oracle database. We are seeing frequent failures in calls to our service. When I looked at the …

oracle hibernate indexing ora-00001

Set default schema = SOMETHING in oracle using Spring Boot and Spring JDBC

I am working now with oracle and spring jdbc but I don't want to use the schema in my sql …

oracle spring-boot spring-jdbc

BEA-141297 - Could not get the server file lock

Following error is encountered when trying to start Oracle Weblogic Server: <Info> <Management> <BEA-141297> &…

oracle server locking weblogic