What is Data Concarency and Consistency?1 4484
How can you create Cursor with parametres ?3 5969
How you will create Toad Function?1 15763
in a package one procedure is wrong package shows valid or not4 5617
is it mandatory to select all the column in a view then what columns should be selected2 4360
difference between pl/sql table and normal pl/sql table2 10422
Why stored procedure is better than query?
What is a schema sql?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
What is the basic structure of an sql?
Why do we use %rowtype & %type in plsql?
What is sql and its types?
What has stored procedures in sql?
Do stored procedures prevent sql injection?
How to display the current date in sql?
How to raise user-defined exception with custom sqlerrm ?
What are different types of sql commands?
Does mysql support pl sql?
what is the difference between delete and truncate commands? : Sql dba
What is group by in sql?
Is primary key an index?