What are analytical functions and how are they used?
Latest Answer: Analytic functions compute an aggregate value based on a group of rows. They differ from aggregate functions in that they return multiple rows for each group. The group of rows is called a window and is defined by the analytic_clause.for example:SQL> ...
How do you create nested tables?
How to create temporary table? Give some example
Latest Answer: create table temp as select*from base table where 1=1; ...
Hi Can anyone explain what this mean? I have practise PL/SQL about REF obj_type, my codes are: CREATE or REPLACE TYPE home_type AS OBJECT (street VARCHAR2(50), city VARCHAR2(20), state VARCHAR2(20), zipcode
Latest Answer: I checked the code it's working fine. ...
What is the difference between Nested Table and Normal Table?
Latest Answer: Normal Table : It contain rows and columns.Each Row-Column represente only one value i.e intersection of Row-Columncreate table t1(col1 number(10), col2 varchar2(9));------>Creates normal tableNested Table : It contains some Row-Column as another ...
User Interface accepts the Employee information and this data needs to be compared with the existing data and the differences needs to be populated through a Pl/SQL table.Create a type (EMP_DATA) to populate
What is the difference between a package and a module?
Latest Answer: Module is a collection of Package ...
How to query the customer details from a Table who have purchased No. of items greater than 5?
Latest Answer: select column 1,...column n from table namewhere purchaseno 5 order by purchaseno;try this one .....ThanksRAJIV GUPTA YOGIK TECHNOLOGIES PVT LTD.JAMSHEDPUR ...
What are the diffrences between Oracle 8i and Oracle 9i as a Developer, not as a DBA??
Latest Answer: ISQl*plus and J-server is not there in oracle-8i which are there in 9iBismita ...
For each hour, list the number of called, total transactions' values, and total duration?if you have these tables:1- 'calls'columns: called_number, Customer_ID, call_date, call_time_started,
View page << Previous 1 2 [3] 4 5 6 7 8 9 10 Next >>
Go Top
