Interested to Buy Any Domain ? << Click Here >> for more details...
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
2005which institute and which faculty is providing best training for oracle sql, plsql in hyderabad
4 5665if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.
1 3922i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.
1 3445t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.
2 3678if i am using dml statement in function. then i am writing select statement what was the output
2 4463The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL
TCS,
1 3434The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6
TCS,
2 4133Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
TCS,
1831Post New Oracle General Questions
Explain what are the different type of segments?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
How to define a variable of a specific record type?
How to bring a tablespace online?
Explain oracle data types with examples?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What are the different windows events activated at runtime ?
How to retrieve the count of updated rows?
What happens to the data files if a tablespace is dropped?
How to write an inner join with the where clause in oracle?
What is the difference between count (*), count (expression), count (distinct expression)?
master table and child table performances and comparisons in Oracle ?
What is the difference between sharding and partitioning?
How to create id with auto_increment on oracle?
