OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » SQLPLUS

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQLPLUS [message #10649]

Fri, 06 February 2004 19:55

M Al-Tal
Messages: 1
Registered: February 2004

Junior Member

Which sqlplus commands can be used to get information about:

1. To list the name of the existing tables?

2. To list the current Database size (in MB)?

Thanks

Report message to a moderator

Re: SQLPLUS [message #10650 is a reply to message #10649]

Sat, 07 February 2004 00:05

manga
Messages: 3
Registered: February 2004

Junior Member

how to give values for the old records in the new column which is added to a table

Report message to a moderator

Re: SQLPLUS [message #10651 is a reply to message #10650]

Sat, 07 February 2004 00:09

manga
Messages: 3
Registered: February 2004

Junior Member

why cursors and triggers are used

Report message to a moderator

Re: SQLPLUS [message #10652 is a reply to message #10651]

Sat, 07 February 2004 00:13

manga
Messages: 3
Registered: February 2004

Junior Member

for what purpose a stored procedure or a pl/sql block used in a project

Report message to a moderator

Re: SQLPLUS [message #10653 is a reply to message #10649]

Sat, 07 February 2004 11:42

William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK

Senior Member

ALL_ALL_TABLES lists all tables accessible to the current user. I don't see what that has to do with SQL*Plus though.

Report message to a moderator

Previous Topic:	Two-dimensional pl/sql tables?
Next Topic:	Output a column

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 21:40:14 CDT 2024