Top "Oracle" questions

How to display databases in Oracle 11g using SQL*Plus

With help of this command show databases; I can see databases in MySQL. How to show the available databases in …

oracle oracle11g sqlplus

Select count(*) from multiple tables

How can I select count(*) from two different tables (call them tab1 and tab2) having as result: Count_1 Count_2 123 456 I've …

sql oracle count

embedding image in html email

I'm trying to send a multipart/related html email with embedded gif images. This email is generated using Oracle PL/…

html image oracle email mime

ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist

I am getting the above error when trying to connect to a server database from a client using service name …

oracle oracle11g ora-01034 ora-27101

How can i introduce multiple conditions in LIKE operator

I want to write an SQL statement like below: select * from tbl where col like ('ABC%','XYZ%','PQR%…

sql oracle

Oracle date "Between" Query

I am using oracle database. i want to execute one query to check the data between two dates. NAME START_…

sql oracle oracle10g where-clause date-arithmetic

How do I use variables in Oracle SQL Developer?

Below is an example of using variables in SQL Server 2000. DECLARE @EmpIDVar INT SET @EmpIDVar = 1234 SELECT * FROM Employees WHERE EmployeeID = @…

sql oracle variables declare

SQL Query to concatenate column values from multiple rows in Oracle

Would it be possible to construct SQL to concatenate column values from multiple rows? The following is an example: Table …

sql oracle string-aggregation

Oracle SQL Query for listing all Schemas in a DB

I wanted to delete some unused schemas on our oracle DB. How can I query for all schema names ?

oracle plsql

How to refresh materialized view in oracle

Iam trying to refresh the materialized view by using: DBMS_MVIEW.REFRESH('v_materialized_foo_tbl') But it's throwing invalid …

oracle materialized-views