Top "Oracle" questions

oracle - what statements need to be committed?

What are the list of statements that need to be committed before further action on the table in order to …

sql database oracle session commit

Using IF ELSE in Oracle

As a web developer, I know how to use the IF ELSE in multiple languages. However, I am learning how …

sql oracle toad

Is the 'as' keyword required in Oracle to define an alias?

Is the 'AS' keyword required in Oracle to define an alias name for a column in a SELECT statement? I …

sql oracle alias required

How to get UTC value for SYSDATE on Oracle

Probably a classic... Would you know a easy trick to retrieve an UTC value of SYSDATE on Oracle (best would …

oracle timezone utc

Rewrite left outer join involving multiple tables from Informix to Oracle

How do I write an Oracle query which is equivalent to the following Informix query? select tab1.a,tab2.b,…

sql oracle left-join informix outer-join

How can I select from list of values in Oracle

I am referring to this stackoverflow answer: How can I select from list of values in SQL Server How could …

sql oracle select oracle11g

How do I change the default schema in sql developer?

I don't see any tables in the tables section of a database that I've linked to w/ SQL developer. The …

oracle oracle-sqldeveloper

Searching for Text within Oracle Stored Procedures

I need to search through all of the stored procedures in an Oracle database using TOAD. I am looking for …

sql oracle stored-procedures full-text-search toad

Sequence Permission in Oracle

How can I check a permission granted for particular sequence and assign permission to particular sequence from SQL*Plus. Thank …

oracle sequence

How to increase buffer size in Oracle SQL Developer to view all records?

How to increase buffer size in Oracle SQL Developer to view all records (there seems to be a certain limit …

sql oracle oracle11g oracle-sqldeveloper