Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
What is java sql package?
How would you hide a table in sql. ie the table can be only visible to its maker?
how does a local variable is defined using t-sql? : Transact sql
What is case function?
How can you fetch common records from two tables?
How do we accept inputs from user during runtime?
Explain the components of sql?
how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);
What is integrity constraints?
How do you declare a user-defined exception?
What is an escape character in sql?
what is mean by forward declaration and where we'll use it.