iceman29

Hi, I am trying to generate a spool file through below anonymous block in order to find out views on a particualar table. declare cursor c1 is select view_name,text from users_view; rt c1%rowtype; begin open c1; loop fetch c1 into rt; exit when c1%notfound; dbms_output.put_line(rt.view_name || '|' || rt.text); end …

Hi Dipti, You can use the below querry to get the table names in your DB: [code] select * from tab; [/code]

If you are just interested in viewing the names and not the other info about tables, you can use [code] select * from tab [/code]

Hi, Is it possible to display the output of a C program in different font sizes by setting it in the code? If yes, please guide regarding the same. Thanks.

Hi , Can we have an sql query to get the max 5 values from a column? Please paste a sample code if its possible. Thanks in advance.

Actually, the below command gives the time as per GMT : [code] date -u [/code] where as on using [code] date [/code], we get the time according to what we have set our time zone (TZ) as.

Hi, I am writing a shell script, and need help with a small piece of code. It is as below: [code] CUST_1=filename b=1 c=$CUST_$b echo $c [/code] I want the output from this as filename, whereas I get it as 1. Please guide as if where am I going wrong …

Hi, I am not able to use any USB device on my PC(Win XP). and looking for help on this issue. Whenever I connect any pen drive or i pod to the USB port, it shows a balloon saying the name of the device connected and the install driver set …

can also name the file as shellProgramming.sh and diretly run it by giving it as sh shellProgramming.sh on the prompt.