Categories

JAVA DATEBASE
Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Java
Desktop
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Architecture
Migration and Modernization
E-Business Suite
Siebel
PeopleSoft Enterprise
JD Edwards World
Industries
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Primavera
ATG
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums

 



Tags

General Questions


double quotes in query


Hi   I get the last query executed using the ora_sql_txt (sql_text) function for some auditing. Now on some server I get the last query as  select columnname from "schemaname"."tablename"; i.e I get double quotes as extra.  while on some I get without double quotes select columnname from schemaname.tablename;  Is there some setting in oracle for this.  I am using oracle 10g  Sapan

I don't think there is any such setting in Oracle. Its just the way the queries are executed by end user (application/tool that they are using).

but when I try executing the query as  select something from "schema_name"."tablename";  it gives table not exists errror  but   select something from schema_name.tablename;  returns query as select something from "schema_name"."tablename";  using the function

When included in double quotes, the object names have to be used in the same case in which they were created.  F. ex. table TEST created as "Test" cannot be accessed as "test" or "TEST" and so on. It must be accessed as "Test" only.

Thanks satish  I got the point


Related Links

The domain associated to the DB Link
tkprof and explain plan output for another session
query performance
v$sql_bind_capture – is it buggy?
UNABLE TO ALLOCATE 34824 BYTES OF SHARED MEMORY
UNABLE TO ALLOCATE 34824 BYTES OF SHARED MEMORY
Rebuilding Table in oracle9i
ORA-24778 Cannot Open Connections
trace file
TNS-12560: TNS:protocol adapter error listener not starting up.
How can I legally gain access to support.oracle.com ?
XA transactions & dblinks
Schema comparison
Heavy swapping observed on system
ORA-08103 Error. Please guide
ORA-12012: error on auto execute of job 965257