I\'ve got an SQL-table with some million entries and I tried to query how much entries are older than 60 days (Oracle 11.2.0.1.0).
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.
I have been trying to move away from using DECODE to pivot rows in Oracle 11g, where there is a handy PIVOT function.But I may have found a limitation:
i am creating a trigger and receiving some error, which i m not able to understand. Pls can anyone help me with that.
I want to retrieve rows from an oracle table and convert them into o开发者_运维知识库bjects. I am currently using a refcursor result and a datareader in c# to manually convert the rows to objects but
MySQL supports events where i can set up something to happen in a specified time period Eg: Update the salary\'s every month
I need to retrieve data from an oracle table using a pl/s开发者_如何学Cql stored procedure and odp.net. What is the standard way of doing this?PL/SQL has the ability to return sets of data using Ref C
TYPE point IS RECORD ( X NUMBER,-- The X co-ordinate of the point Y NUMBER-- The Y co-ordingate of the point
I want to delete all the data rows in the table, but without dropping the table. The delete statement has a where clause so I have to give one by one for each row. Is there any other way of deleting t
Is there a way to give a subquery in Oracle 11g an alias like: select * from (select client_ref_id, request from some_table where message_type = 1) abc,
加载中,请稍侯......