Search Oracle 9i Sql Solutions

	Login \| Register

34 Solution(s) found

Oracle 9i Sql

A Common Exception in Oracle

If an exception occures when you try to initialize a package level variable, it will be propogated unhandled out of package, even if the initilization section contans a Exception section. In this situation the PL/SQL engine registers the package as initialized and allows you to continue to reference varibale and subprograms in package.

Oracle 9i Sql

oracle certified professional

Which of the following events results in Automatic rollback

Oracle 9i Sql

Nth max salary using Analytic function

How to get Nth max salary using analytic function?

Oracle 9i Sql

How to capture clinet machine ip address through application?

I have a 10g application. I want to capture the ip address of each local / client machine who connects to my applcation via proper user id and password.

Oracle 9i Sql

Oracle 9i , PL/SQL , Data Base

Which is the only keyword in oracle has two different implentations?

Oracle 9i Sql

How to Execute SQLString in procedure?

We need SQLString(Nested Select statement) execute for find count and assign one variable. That variable will use in condition

Oracle 9i Sql

WRITING PROCEDURE in Teradata DataBase and in Oracle

The problem is while writing the procedures .The procedure syntax is diffrent from ORACLE and TeraData. so I have given here one example .How to write a Procedure in Teradata database.

Oracle 9i Sql

WRITING PROCEDURE Teradata DataBase

The problem is while writing the procedures .The procedure syntax is diffrent from ORACLE and TeraData. so I ahhve give here one example .How to write a Procedure in Teradata database.

Oracle 9i Sql

Advanced use of DECODE

How can we get greater of two numbers using decode

Oracle 9i Sql

Static and dynamic SQL

What is basic difference between Static and Dynamic SQL