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 achieve this? Answer It does not make sense to include
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 question, Oracle documentation). Something like this: and: Set
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 readability and flexibility of my SQL statements. Is there any possible way to combine these two
(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 ( …