How to find text in oracle stored procedure USE : user_source tableselect * from user_source where type = ‘PROCEDURE’ and lower(text) like lower(‘%text%’); Share this: Share on X (Opens in new window) X Share on Facebook (Opens in new window) Facebook Share on Reddit (Opens in new window) Reddit Share on Pinterest (Opens in new window) Pinterest Share on X (Opens in new window) X Share on LinkedIn (Opens in new window) LinkedIn Share on WhatsApp (Opens in new window) WhatsApp Share on Tumblr (Opens in new window) Tumblr Share on Nextdoor (Opens in new window) Nextdoor Share on Mastodon (Opens in new window) Mastodon Share on Telegram (Opens in new window) Telegram Like this:Like Loading… Related
Oracle 9i Tutorial Oracle Interview Questions Oracle 9i Tutorial : What is syntax of DELETE Statement Syntax abhisanto December 30, 2010 0 You can remove existing rows by using the DELETE statement. Delete Statement Syntax below : DELETE [FROM] table [WHERE condition]; Share this: Share on X (Opens in new window) X Share on Facebook (Opens in new window) Facebook Share on Reddit (Opens in new window) Reddit Share on Pinterest (Opens in new window) Pinterest Share on X (Opens in new window) X Share on LinkedIn (Opens in new window) LinkedIn Share on WhatsApp (Opens in new window) WhatsApp Share on Tumblr (Opens in new window) Tumblr Share on Nextdoor (Opens in new window) Nextdoor Share on Mastodon (Opens in new window) Mastodon Share on Telegram (Opens in new window) Telegram Like this:Like Loading…
Oracle 9i Tutorial Oracle Interview Questions Oracle 9i Tutorial : ALTER TABLE Statement abhisanto December 26, 2010 0 ALTER TABLE Statement After you create a table, you may need to change the table structure because: you omitted column, your column definition needs […] Share this: Share on X (Opens in new window) X Share on Facebook (Opens in new window) Facebook Share on Reddit (Opens in new window) Reddit Share on Pinterest (Opens in new window) Pinterest Share on X (Opens in new window) X Share on LinkedIn (Opens in new window) LinkedIn Share on WhatsApp (Opens in new window) WhatsApp Share on Tumblr (Opens in new window) Tumblr Share on Nextdoor (Opens in new window) Nextdoor Share on Mastodon (Opens in new window) Mastodon Share on Telegram (Opens in new window) Telegram Like this:Like Loading…
Oracle 9i Tutorial Oracle Interview Questions What are few Oracle DDL statements or commands ? abhisanto March 2, 2011 0 Below are few DDL commands to create, alter, drop, and rename tables. CREATE TABLE Create a table. Create a table based on another table by […] Share this: Share on X (Opens in new window) X Share on Facebook (Opens in new window) Facebook Share on Reddit (Opens in new window) Reddit Share on Pinterest (Opens in new window) Pinterest Share on X (Opens in new window) X Share on LinkedIn (Opens in new window) LinkedIn Share on WhatsApp (Opens in new window) WhatsApp Share on Tumblr (Opens in new window) Tumblr Share on Nextdoor (Opens in new window) Nextdoor Share on Mastodon (Opens in new window) Mastodon Share on Telegram (Opens in new window) Telegram Like this:Like Loading…