how are rank and dense rank being alloted for column with same values over a particular column1 288
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?147
What is Difference Between Unique and Primary Key Constraints?9
What is a Mapplet?9
How to change the order of columns in Oracle SQL Plus ?10
How to display Row Number with Records in Oracle SQL Plus?10
How to display the records between two range in Oracle SQL Plus?15
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?12
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?12
Can a procedure in a package be overloaded?
Can procedure in package be overloaded?
Can procedure in a package be overloaded?
Inline the values in PL/SQL, what does it mean.?13
How can we store rows in PL/SQL using array?13
How to display Row Number with Records in Oracle SQL Plus?
what is the bond code in materialized view?
What are the two types of exceptions.
Explain polymorphism in pl/sql.
What is an intersect?
Show the cursor attributes of pl/sql.
When is a declare statement required?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
What operators deal with null?
what is single byte over head in oracle..?
Can a commit statement be executed as part of a trigger?
How is a PL/SQL code compiled?
What are the key differences between SQL and PL SQL?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?