No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
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 … |
|
Re:
Hi I have created many tables in database. Now when i used to create new table that's name may already exists. So, before creating new table i must know which table names are already exists in my database. And for that i want to display all the tables created in … |
|
Re:
Like the DESCRIBE statement used to view columns in a given table, What SQL statement can i use to view the tables in a database. (Oracle 10g) |
|
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. |
|
Re:
HI Guys, Prob a very simple one but im stumped, I run the following command and get: [code] date Wednesday, 19 August 2009 09:20:59 BST [/code] But when I run [code] date -u '+%y%m%d.%H:%M:%S' 090819.08:21:27 [/code] My question is why is the second command an hour behind? In my environment … |
|
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 … |
|
Re:
i used vi: %vi shellProgramming and then i typed the shell script in the vi and saved with :wq However, when i run the vi file ...... %shellProgramming my unix says "command not found" why is that? and how do i run the vi shell scripting file? thanks |