inputing a (table/tablespace name) at script level.

sir,
i would like to have a simple form of shell script , which can
take a table or tablespace as input at script level(o/s} and provide me a database o/p at script level.Basically giving an input table name at script level then at sql level.

pls help .thanks in advance.


sanctus.

I am not sure I understand. Would like to pass parameter from shell script to sql script?

You can pass parameters to sqlplus after script like
sqlplus user/pass@db @script.sql param1 param2

In sql script you reference the parameters as &n where n is the position of parameter, like &1, &2.