What does “select count(*) from tab” result?

Answer Posted / kamal kishore kashyap

display all the table which are currently in the schema.

Is This Answer Correct ?    0 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are local and global variables and their differences?

804


The select into statement is most often used to create backup copies of tables or for archiving records?

768


Define a temp table?

751


How many times can we commit in a loop?

738


How much does a sql dba make? : SQL DBA

666






What are the different tcl commands in sql?

815


Define tables and fields in a database

829


discuss about myisam key cache. : Sql dba

760


Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

2258


What is data profiling in sql?

734


Explain autonomous transaction.

839


How to use sql statements in pl/sql?

798


What are schema-level triggers?

753


Do foreign keys improve performance?

745


How do I start sql from command line?

705