|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Latest Answer : set con=createobject("ADODB.connection")set rs=createobject("ADODB.recordset")set cmd=createobject("ADODB.command")con.provider=(Microsoft.jet.oledb.4.0")con.open "select the path of the database"rs.open "enter ... Will the ‘View’ get refreshed immediately when you update a database table. If it doesn’t get refreshed immediately, what method you use to refresh it ? Read Answers (3) | Asked by : ronin Latest Answer : Trigger :- It is a type of stored procedure invoked automatically for a predefined DML operation .cannot accept parameters.Stored Procedure :- It includes trigger ,function .Stored procedure(Function and procedure) need to execute explicitly by ... View Question | Asked by : vinay Latest Answer : hi, IN is used to pick one by one value from a list of values.Supports numbers,chars,dates.It is a special operator. Exists: It is also a special operator but it returns a BOOLEAN value. ... Read Answers (1) | Asked by : surya prasad View Question | Asked by : abhishek Latest Answer : FeatureSimple ViewsComplex ViewsNumber of tablesOneOne or moreContain functionsNoYesContain groups of dataNoYesDML operations through a viewYesNot alwaysRegards,Rajakumar.N ... View Question | Asked by : sai Latest Answer : only the size differs in nvarchar2 length is much more compare to varchar2 ... What is the difference between Case and Decode?In what situation we can use Case and Decode Latest Answer : DECODE works with expressions which are scalar values.CASE can work with predicates and subqueries in searchable form:CASE is an ANSI standard, where as Decode is proprietary for OracleWe can use expressions as part of case statements, where as Decode ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0 
1