how are rank and dense rank being alloted for column with same values over a particular column
1 2402Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
1269
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
How can check sql version from command line?
what is innodb? : Sql dba
Can we have two clustered index on a table?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
how do you control the max size of a heap table? : Sql dba
How to use distinct and count in sql query? Explain
What is function and procedure in pl sql?
Mention what pl/sql package consists of?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
Is it possible to create the following trigger: before or after update trigger for each row?
Write a sql select query that only returns each name only once from a table?
What are the two different parts of the pl/sql packages?
What is indexing oracle sql?
What are the advantages of pl sql over sql?