What are analytical functions in sql?
how to insert the records in particular position
Explain locks? : Transact sql
Can we join tables without foreign key?
how many no of table can be join in a sql query.
Do you know the basic structure of PL/SQL?
Is sql a dbms?
what is the stuff function and how does it differ from the replace function? : Sql dba
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.
What can you do with pl sql?
What is ROWID?
Can delete statement be rollbacked?