I have to call a procedure multiple times that then populates a tab开发者_开发百科le. Problem is the procedure truncates the table after each call. I have to store the results of the table for each ru
This has gotten me a little paranoid, but I\'m retrieving a set of records that fall within a period of time, say, the period from the january 1, 2011 (starting at midnight) to march 31, 2011 (all rec
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references,or expertise, but this question will likely solicit debate, a
I need a bit of help with my SQL*Plus script. Is there any way I could have it so that it will accept a variable, check the table for a match and if it finds it exit the program and not continue with
How could I have a trigger that updates a certain field when the system reaches a certain date ? i.e.
I am new to using PL/SQL and I am trying to create a new stored procedure in an existing package. I realize that there is "CREATE OR REPLACE PACKAGE BODY," but does this mean that the entire
The same query ran in PL/SQL Developer shows time, however it does not show in Oracle SQL Developer. Is there a way to get开发者_运维问答 the time in SQL Developer?
I have a two table.I want to get the below result out from these two table. Any help appreciate. EVENT table
Greetings everybody, I came across the feature of using java in oracle, a few days back. Ever si开发者_运维百科nce I am wondering about the
In Oracle DBMS, which is better performance, calling a java stored procedure from another pl/sql stored procedure or calling a pl/sql stored procedure from another pl/sql stored procedure.
加载中,请稍侯......