Top "Oracle" questions

Update rows in one table with data from another table based on one column in each being equal

Update many rows into one table from another table based on one column in each being equal (user_id). both …

sql oracle sql-update

What is a View in Oracle?

What is a view in Oracle?

database oracle views

How to display Oracle schema size with SQL query?

I have a Oracle schema with 70+ tables. I want to create simple page which can display the HDD space occupied …

sql oracle oracle11g

How to insert a string which contains an "&"

How can I write an insert statement which includes the & character? For example, if I wanted to insert "J&…

sql oracle escaping sqlplus

Difference between CLOB and BLOB from DB2 and Oracle Perspective?

I have been pretty much fascinated by these two data types. According to Oracle Docs, they are presented as follows : …

database oracle db2 blob clob

How to display table data more clearly in oracle sqlplus

I want to be able to display the resulting data from a select in a pretty way, not all columns …

database oracle sqlplus

UPDATE with CASE and IN - Oracle

I wrote a query that works like a charm in SQL Server. Unfortunately it needs to be run on an …

sql oracle sql-update

Oracle SQL: Use sequence in insert with Select Statement

Basically I want to run the following query: INSERT INTO historical_car_stats (historical_car_stats_id, year, month, make, …

sql oracle plsql insert sequence

check if "it's a number" function in Oracle

I'm trying to check if a value from a column in an oracle (10g) query is a number in order …

oracle plsql oracle10g

How do I get a list of locked users in an Oracle database?

I want to be able to list all of the users in a given database along with an icon that …

oracle system-administration locked