Loop Through Date Range
Hi guys,
I have date range as parameter like 01/JAN/2009 TO 16/JAN/2009 now i want to loop through this date range and want to get date like
01/JAN
All possible combinations of String in PL/SQL
Hi All,
Could you please explain the logic of getting all possible combinations of String in PL/SQL?
For ex if "HER" is string
then the output s
Add weeks in a query?
I have a SQL that summarizes the quantity per week. The weeks that has no value does not exist in the table. How can I add these missing weeks with a
All possible combinations of Strings from table in PL/SQL
Hi,
I am trying to figure out how to build a list of all possible string combinations from values stored in a single table.
There are multiple "
with clause
hi all, i have a big query that usually access the same table more than once. for example, i have something like this
select
why this query can delete duplicates ?
why this query can delete duplicates ? Anybody can give me the detailed explanation ?
Thanks
select salary from employees union select salary fr
Calling a Procedure with IN & OUT Parameters
Hello,
I usually call my procedures using the following way
declare variable error_msg varchar2(50)
exec simple_msg('ABC,'ABC','ABC',:error_msg
Varible in trigger - refering to correct schema
Hello
Im having some issues with my trigger.
What I want to do is call opon a different schema - depending on which data the triggers picks up.
quick question about System Change Number(SCN) in FlashBack Query topic
i know tht we can get the SCN of the database using flashback concept as follows
SQL> execute :myvariable:=dbms_flashback.get_system_change_numb
Request for tunning the below query
Hi,
Can any one help me on the below query while improving the performance,
SELECT accdet, acceprec, accinvalid, accnetanal, accphy, accvalid,
insert Multiple rows into the table from that table data
Hi All,
I have a requirement like to insert mulitple rows into the table from that table data only(I need to replicate the data).
In this ta
Error when call dll from oracle
Hi all, please help me!
I have dll write C language, I want call it from oracle procedure but it throws the error: "ORA-28546: connection initiali
present value of sequence?
Hi
Please help me to find out the present value of sequence?
Thanks
Oracle Connectivity
Hi Every One,
Can we access SAP from oracle database.If it possible then please specify the list of steps(i.e connectivity) to access SAP from
Count number of records in all the tables with a querry URGENT PLEASE...
I downloaded ORACLE 9I DATA DUMP into my comp. There are number of tables. I need to find out the tables with records more than say 100 or so at on
Help on query replacing the date
Hi Pals,
i want to replace the current date in a column to some value say C or D or any numeric value , likewise the NVL function which replaces th
Error when call dll from oracle
Hi all, please help me!
I have dll write C language, I want call it from oracle procedure but it throws the error: "ORA-28546: connection initiali
Logging and nologging bulk insert
Hi,
oracle version: 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
I am trying to use Append during bulk insert?
example:
in
present value of sequence?
Hi
Please help me to find out the present value of sequence?
Thanks
How to insert random unique values in 2 columns ?
I have table with 2 columns
Create Table code_for_code (
first_code varchar2(10) unique not null,
second_code varchar2(10) unique not null );
