Can somebody explain this error? ORA-00054: Resource busy and aquire with NOWAIT specified This error came in a DROP TABLE. Because of it, procedures and packages are not getting compiled.
Tag: oracle
How do I select dates between two given dates in an Oracle query?
How do I select dates between two given dates in an Oracle query? Answer from http://forums.devshed.com/oracle-development-96/select-all-dates-between-two-dates-92997.html
How to Select and Order By columns not in Groupy By SQL statement – Oracle
I have the following statement: There exists some extra columns in table Positions that I want as output for “display data” but I don’t want in the group by statement. These are Site, Desk Final output would have the following columns: Ideally I’d want the data sorted like: How to achi…
Select Nth Row From A Table In Oracle
How can I select the Nth row from a table in Oracle? I tried but that didn’t work. Please help! Answer Based on the classic answer: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:127412348064
Average of Sum minus Minimum
I have an SQL statement that grabs the grades of different activity types (Homework, Quiz, etc), and if there’s a drop lowest for that type, it drops, else, it remains. The errors are below as well as the SQL Code. Here are the errors I’m getting: Answer Look into analytical functions. (SO questio…
Insert Fail because of wrong non-numeric character
hy table: create table Players (PlayerNo number (4) not null, Name varchar2(15), date_of_birth date,leagno varchar(4)); wrong insert: insert into PLAYERS (PlayerNo,Name,date_of_birth,leagno) …
How can I see the contents of an Oracle index?
Is it possible to have a look at what is there inside an index using SQL*Plus? If I have a table like this: Table A ———————— rowid | id name 123 | 1 A 124 | 4 G 125 …
Oracle join query
There are three tables in my db: ITEM_MASTER, PRICE_MASTER and COMP_MASTER. ITEM_MASTER STORE_CODE ITEM_CODE ITEM_DESC 011 914004 desccc PRICE_MASTER STORE_CODE ITEM_CODE COMP_CODE …
Is there a combination of “LIKE” and “IN” in SQL?
In SQL I (sadly) often have to use “LIKE” conditions due to databases that violate nearly every rule of normalization. I can’t change that right now. But that’s irrelevant to the question. Further, I often use conditions like WHERE something in (1,1,2,3,5,8,13,21) for better readabilit…
(Oracle) How get total number of results when using a pagination query?
I am using Oracle 10g and the following paradigm to get a page of 15 results as a time (so that when the user is looking at page 2 of a search result, they see records 16-30). select * from ( …