sql - ROWNUM returns as "invalid identifier" -

-

i running basic select against oracle database (not sure of version).

select * accounting id = 123456 order date

i want return recent record. have tried ...

select rownum, * accounting id = 123456 order date select * accounting id = 123456 , rownum < 2 order date

i same result every time ...

error source: system.data.oracleclient     error message: ora-00904: "rownum" : invalid identifier

everything see , read suggests should work. can see missing? issue driver? using following package ... (oracle odac 11.20.30 x64)

update

thank replies ... apologize confusion created in efforts simplify scenario. odac driver breaking query out , formatting me, posted not exactly query being run ... here's, driver spitting out generating error ... 

select "rownum", id, site_id, reading_date, submitted_date, deposit_date    accounting   (site_id = 33730) order reading_date

and second attempt ...

select id, site_id, reading_date, submitted_date, deposit_date    accounting   (site_id = 33730) , ("rownum" < 2) order reading_date

your actual query might using rownum within double quotes. otherwise, error not possible.

though first query ora-00936: missing expression

select * dual "rownum" < =3;  error report - sql error: ora-00904: "rownum": invalid identifier 00904. 00000 -  "%s: invalid identifier" *cause:     *action:

rownum pseudo-column , function without parameters.. , way "rownum" makes oracle search such column in table..

quoted identifiers when oracle reserved keyword, surpass original purpose, , behaves user defined column.

unsure, of how stop query builder interpret way. consider bug.


Comments

Post a Comment

Popular posts from this blog

javascript - gulp-nodemon - nodejs restart after file change - Error: listen EADDRINUSE events.js:85 -

-
i'm running nodejs 0.12.3 - gulp 3.10.8 , gulp-nodemon 2.0.3. gulpfile.js : gulp.task('serve', ['build'], function() { gulp.start('fb-flo'); nodemon({ script: paths.server, env: { 'node_env': 'development' }, // env: { 'node_env': 'production' }, execmap: { 'js': 'node_modules/babel/bin/babel-node --stage 1' //es7 cote server }, delay: '0ms', watch: ['src/shared/', 'src/server/'], ignore: ['src/shared/components'], tasks: function (changedfiles) { var tasks = []; changedfiles.foreach(function (file) { if (path.extname(file) === '.jsx' && !~tasks.indexof('bundlejs')) tasks.push('bundlejs'); if (path.extname(file) === '.less' && !~tasks.indexof('compileless')) tasks.push('compileless'); }); return tasks; } ...
Read more

Fatal Python error: Py_Initialize: unable to load the file system codec. ImportError: No module named 'encodings' -

-
i trying make simple python program opening list of webpages user manually download reports site. don't have previous experience preparing exe files.. , i'm in learning process python coding. of done on windows 7 x64 this python code: #!c:/python34/python.exe -u splinter import * import time import os import csv #---------------------------------- raporty = [] open('../raporty.csv', newline='') csvfile: contents = csv.reader(csvfile, delimiter=' ', quotechar='|') row in contents: r = ', '.join(row) r = r.replace(',','') raporty.append(r) #--not implemented yet zmienne = [] open('../zmienne.csv', newline='') csvfile: contents = csv.reader(csvfile, delimiter=' ', quotechar='|') row in contents: r = ', '.join(row) r = r.replace(',','') zmienne.append(r) print("start") browser = browser(...
Read more

javascript - oscilloscope of speaker input stops rendering after a few seconds -

-
the following script reads audio user's microphone , renders oscilloscope on html canvas. the source taken example of mozilla developer network: visualizations web audio api and here fiddle: http://jsfiddle.net/b7j8pktp/ mozgetusermedia (note: code has no fork mechanism different browsers: works firefox) it works fine few seconds , stops rendering. whereas works totally stable: http://mdn.github.io/voice-change-o-matic/ the problem can reduced following code. microphone activation icon (next the address bar in firefox) disappears after 5 seconds: navigator.mozgetusermedia({audio: true}, function() {}, function() {} ); ( http://jsfiddle.net/b7j8pktp/2/ ) this known bug in firefox. take stream getusermedia call , hook window so: navigator.mozgetusermedia({audio: true}, function(stream) { window.stream = stream; // rest of code }, function err() { // handle error }); hopefully can fixed soon. problem we're f...
Read more