Latest Answer: Types of functions in OracleAggregate functions Avg, Count, Sum, RankAnalytic Functions Lag, Lead, Ratio_to_report, First_value, Last_valueCharacter Functions Instr, Trim, Length, Lower, Upper, Replace, TranslateConversion Functions To_char, To_date, ...
Latest Answer: Depends on when you commit the changes. If u are processing like above (in a for loop) you should commit post processing, after the cursor is closed. But that's often not useful on huge amount of data. any commited transactions to cursor data while the ...
Latest Answer: implicit ,explicit,ref cursor ...
Latest Answer: In Sybase(T-SQL), there are 3 types of joins1) Equi Join2) Natural Join3) Outer Join (left & right)Joins based on equality (=) are called equijoins. Equijoins compare the values in the columns being joined for equality and then include all the columns ...
Latest Answer: contents or data of the table can be sorted by using clause ORDER BY in SELECT statement.By default the table is in ASCENDING order.SYN: SELECT * from [table name] where [condition] ORDER ...
Latest Answer: DDL=Data Definition Language (Create,Alter,Drop)DML=Data Manipulation Language(Insert,Update,Merge) ...
Latest Answer: send me questions about databases and certifications tools of databases oracle sqlserver please ...
Latest Answer: I would say, write more sql statementfor exin join statement if x=y, y=z (you can also add x=z to give more hint to optimizer) ...
Latest Answer: exceptions can be handled in various ways in the stored procedures. Method (1) could be using EXCEPTION block in the procedure within which use WHEN THEN. Method (2) could be declare a variable in DECLARE section as EXCEPTION type, ...
View page << Previous 3 4 5 6 [7]
Go Top
