Top "Oracle" questions

Functions vs procedures in Oracle

can anybody explain what is the main difference between functions and procedures in Oracle? Why must I use procedures if …

oracle stored-procedures plsql oracle11g stored-functions

How to troubleshoot ORA-02049 and lock problems in general with Oracle

I am getting ORA-02049 occasionally for some long-running and/or intensive transactions. There is seemingly no pattern to this, but …

sql oracle deadlock ora-02049

Select multiple columns into multiple variables

How can I do in one select with multiple columns and put each column in a variable? Something like this: …

sql oracle plsql select-into

Grant Select, Insert, Update to a Tablespace

I've got a lot of tables in a tablespace, nearly 100. I have to grant Select, Insert, Update privileges on all …

oracle select insert grant tablespace

Checking whether an item does not exist in another table

My tables are set up something like this: table name: process fields: name, id_string table name: value_seach fields: …

sql oracle exists anti-join

USE DATABASE command on SQL PLUS ORACLE 11gr1

After successfully installing ORACLE 11gR1 on Windows7 32bit platform, I can go inside the SQL PLUS and I can also …

oracle oracle11g

Difference between oracle DATE and TIMESTAMP

What are the difference between Oracle DATE and TIMESTAMP type? Both have date and time component? Also what is corresponding …

oracle jdbc oracle11g

grant select on view

somewhere along the way something is going wrong, and I can't seem to find out why. If this is already …

oracle select database-schema grant

Oracle SQL Developer multiple table views

In Oracle SQL Developer, one can list the data in a table using the Data tab when viewing a table. …

oracle oracle-sqldeveloper

What is the major difference between Varchar2 and char

Creating Table: CREATE TABLE test ( charcol CHAR(10), varcharcol VARCHAR2(10)); SELECT LENGTH(charcol), LENGTH(varcharcol) FROM test; Result: LENGTH(CHARCOL) LENGTH(…

sql oracle char varchar2