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?
1452which institute and which faculty is providing best training for oracle sql, plsql in hyderabad
4 4029if 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 3116i 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 2617t1 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 2701if i am using dml statement in function. then i am writing select statement what was the output
2 3252The 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 2479The 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 3184Tab 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,
1248Post New Oracle General Questions
Explain oracle’s system global area (sga).
How to name query output columns in oracle?
What is a select query statement in oracle?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
How to define a data field as not null?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
Can multiple cursors being opened at the same time?
What happens if variable names collide with table/column names?
What is a named program unit?
How to get the Installed Oracle Version Information ?
Explain the dml?
How to create additional tablespaces for an new database?
How to drop an existing table in oracle?
How to see the table columns used in an index?