sql - Why does Oracle 12c query require double quotes around table -

-

this question has answer here:

the database i'm querying oracle 12c. detailed info database version follows:

oracle database 12c enterprise edition release 12.1.0.2.0 - 64bit production

pl/sql release 12.1.0.2.0 - production

i'm trying eliminate need have double quotes around every view or table in sql query.

following works (from oracle sql developer gui)

select m."metadata" "evmetadata" m

following gives error (from oracle sql developer gui)

select m.metadata evmetadata m

error is

ora-00942: table or view not exist 00942. 00000 - "table or view not exist" *cause:
*action: error @ line: 2 column: 6

i generated ddl, looks this

create table "evp"."evmetadata"   ("evmetadataid" number(10,0) generated identity minvalue 1 maxvalue 9999999999999999999999999999 increment 1 start 1 cache 20 noorder  nocycle ,   "insertdate" timestamp (6),   "sessionid" nvarchar2(17),   "filechecksum" nvarchar2(32),  "metadata" nclob,  "device" nvarchar2(20),  "user" nvarchar2(20) ) segment creation immediate

so based on @toddlermenot's comment below, possible how table created - double quotes. used orm entity framework code first generate schema me seems orm puts double quotes default.

maybe created table double quotes? using double quotes preserve case , since table name has both upper , lower case letters in example, oracle able find when use double quotes.

without double quotes, oracle uses single case (upper?) irrespective of case might have in table, default.

for example: if create table using

create table "table_name" (blah..)

then must use double quotes in select.

if create table using

create table table_name (blah..)

the select without quote should work correctly. (it work quote if had letters of table's name in upper case)


Comments

Post a Comment

Popular posts from this blog

javascript - How to process users in one specific order using map o each function? -

-
i create cloud function process items in specific order , make network request api each item , update them result of api. i tried this. order not respected , computation of "remainingcredits" wrong. note function "getuserpageview()" make api call , return promise result. query.descending("createdat"); return query.find().then(function(items) { var remainingcredits=0; var promises= _.map(items, function(item){ var credit=item.get("credit_buy"); return getuserpageview(123, new date()).then(function(pageviews){ var usedcredit=credit-pageviews; if(remainingcredits>0) return remainingcredits+credit; if(credit-usedcredit<=0){ console.log("usedcredit:"+usedcredit); item.set("used",true); return 0; }else{ remainingc...
Read more

java - Two interface have same method name with different return type -

-
this question understanding interfaces in java. here simple example of implementing interfaces in java. interface parenta { void display(); } interface parentb { int display(); } class child implements parenta, parentb { @override public void display() { system.err.println("child parenta"); } //error : return type incompatible parentb.display() //so added method int return type @override public int display() { system.err.println("child parentb"); } } this case can happen in large java application 2 interface can have method same name. thought since return type different jvm know interface's method overriding. what best explanation this? situation make sense? thanks in advance because method same signature not allowed, confuses compiler detect exact override-equivalent method declared once. jls (§8.4.2) 2 methods or constructors, m , n, have same signature if have, ...
Read more

javascript - Linking from page A to a specific iframe on page B -

-
i'm in process of setting website showcase our photographs. for using third party supplier providing gallery: http://gallery.wisejam.com/index.html . however, in order keep visitors on our own website, have set gallery on page iframe: http://wisejam.com/gallery-2/ up here, works fine. now, cannot go further when wish deep link post/page photograph open in iframe. it works long visitor on page (gallery-2) following code... <a href="http://gallery.wisejam.com/featured/distortion-clear-waters-robert-schaelike.html" target="iframe_a">distortion</a> however, i'm trying achieve internal links display in iframe of 'gallery-2', not have send them artists' page. wish keep visitors us! i'm sorry if simple question ask i'm not professional programmer. many input , help! you write : target="iframe_a" photos go frame named : name="iframe_a" . please check . if upload full code able gi...
Read more