What is materialized view. What are different methods of refresh?
No Answer is Posted For this Question
Be the First to Post Answer
I have a procedure in a procedure. The inner procedure contains out parameter. How I can call the inner procedure in the out procedure and send the inner procedure parameter value(out parameter value) into out procedure?
When sql appeared?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
What are transaction and its controls?
How to start the command-line sql*plus?
Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F
Which language is used in sql?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
What is java sql connection?
How do you identify a primary key?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
Determine if oracle date is on a weekend?