Q&A Categories

Database

Why the Stored functions cannot called from DML statements?

Why the Stored functions cannot called from DML statements? '

Answers No Answers In: SQL By: @mahesh@ [1 Grey Star Level] Sep 7, 2010

Why the stored functions can not be called from DML Statements? Why cant we modify the database by

Why the stored functions can not be called from DML Statements? Why cant we modify the database by function? '

Answers No Answers In: Stored-Procedures By: claire [1 Grey Star Level] Sep 7, 2010

Why Update is too slow

Why Update is too slow Why the Update Statement works very slowly in Postgresql?'

Answers No Answers In: PostgreSQL By: samir [ Grey Star Level] Sep 7, 2010

Why statistics are different in oracle9i and oracle 10g?

Why statistics are different in oracle9i and oracle 10g? Not sure about this, better we could try again with right samplesize in both the versions. Use DBMS_STATS.AUTO_SAMPLE_SIZE.ExecuteDBMS_STATS.GATHER_SCHEMA_STATS('SCOTT',estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE,GRANULARITY=>'ALL',CASCADE=>TRUE);'

Answers No Answers In: SQL By: sunil [ Grey Star Level] Sep 7, 2010

Why should an oracle client use an OCI based driver as opposed to any other type?

Why should an oracle client use an OCI based driver as opposed to any other type? '

Answers No Answers In: Database By: shoeb [ Grey Star Level] Sep 6, 2010

Why minimum extents are required in roll back segment?

Why minimum extents are required in roll back segment? '

Answers No Answers In: Database-Admin By: jes [ Grey Star Level] Sep 6, 2010

Why is insert faster than delete?Which indexing technique works best for Oracle based database?

Why is insert faster than delete?Which indexing technique works best for Oracle based database? '

Answers No Answers In: SQL By: deva [1 Grey Star Level] Sep 6, 2010

Why order by clause maintains column number values instead of column names ?

Why order by clause maintains column number values instead of column names ? '

Answers No Answers In: SQL By: @mahesh@ [1 Grey Star Level] Sep 6, 2010

Why do i get "Invalid Cursor State" errors when I insert/update/delete data with execute Query()?

Why do i get "Invalid Cursor State" errors when I insert/update/delete data with execute Query()? '

Answers No Answers In: SQL By: ramesh [ Grey Star Level] Sep 6, 2010

Why does the following command give a compilation error?

Why does the following command give a compilation error? DROP TABLE &TABLE_NAME;Variable names should start with an alphabet. Here the table name starts with an '&' symbol.'

Answers No Answers In: SQL By: ramesh [ Grey Star Level] Sep 6, 2010

Didn't find what you were looking for?

Add your Question to the site.

You must be Logged In to Add a Question.

Not a member yet? Sign Up Now »

Star Points Scale

Earn points for Asking and Answering Questions!

Grey Sta Levelr [1 - 25 Grey Star Level]
Green Star Level [26 - 50 Green Star Level]
Blue Star Level [51 - 500 Blue Star Level]
Orange Star Level [501 - 5000 Orange Star Level]
Red Star Level [5001 - 25000 Red Star Level]
Black Star Level [25001+ Black Star Level]