Pergunta de entrevista da empresa Capgemini

The table name will be passed as an input parameter. If a valid table name is provided, the output should return the row count of the corresponding table.

Resposta da entrevista

Sigiloso

22 de jul. de 2025

We can use dynamic SQL to get the row count of the respective table by passing the table name as an input parameter. This can be achieved using EXECUTE IMMEDIATE to construct and run the query at runtime.