forumswhy this query can delete duplicates ?
why this query can delete duplicates ? Anybody can give me the detailed explanation ?
Calling a Procedure with IN & OUT Parameters
Hello,
Varible in trigger - refering to correct schema
Hello
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
Request for tunning the below query
Hi,
Variable uses and placement
I'm new to PL/SQL and am trying to learn about variable valid uses/placement (any pointers to any docs is appreciated...)
Regarding accessing SQL query issued by any user in Oracle 10g
Hi all,
updating a single value to multiple non consecutive rows
I need to update the same value to multiple non consecutive rows. I need to add an experation date to about 6000 parcels.
Regarding accessing SQL query issued by any user in Oracle 10g
Hi all,
HOW to get the bind variables list.
I've the following problem : I've some SQL queries stored in my DB as VARCHAR2 values.
Cursor statement failed with errors
Following statement failed with the errors.
SQL query not working well
Hi,
how to populate a drop down box
Hi buddies!
Casting Decimals in Oracle
This code worked as a query in DB2, but I am not sure what the syntax is for casting decimals in Oracle:
Execure stored procedure on a timer
Can someone tell me an easier way to execute a stored procedure on a timer? I am using Oracle 10g R2 DB on windows 2003 server. I have a batch file that calls an SQL file, which runs fine when I
query help
Hi experts.
Consuming third party Payment Gateway API from Procedure.
Hi All,
Revoking alter any table from a schema
Hi All,
cyrillic string conversion question
Hello,
Random date selection
i want to select random date with time(hour+minutes+sec) where date is specified(10/22/2009) and timestamp is specified 10-11 am
