Can you use a commit statement within a database trigger?4 2678
What WHERE CURRENT OF clause does in a cursor?1 2242
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?1068
which institute and which faculty is providing best training for oracle sql, plsql in hyderabad4 2683
if 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 2311
i 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 1808
t1 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 1897
if i am using dml statement in function. then i am writing select statement what was the output2 2355
The 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
The 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
Tab 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.
How to convert characters to numbers in oracle?
How to establish administrator authentication to the server?
Where is the export dump file located?
How to speed up webrick?
List the various oracle database objects?
How will you write a query to get a 5th rank student from a table student_report?
How do I escape a reserved word in oracle?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
Explain constraining triggers.
How to define a procedure inside another procedure?
What are the components of logical database structure in oracle database?
What is an anonymous block?
Explain integrity constraints?
What is difference between truncate and delete?
How to start an oracle instance?